Registered aircraft · 689

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:96-24-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-24-13') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:96-24-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-24-13')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:96-24-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-24-13')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N131MPN Registration Service LLC Trustee · Sanford, NCS/N 31P-7400193 N131PCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 31T-7820009 N131PJCrosswinds Flight Center Inc · Drums, PAS/N 31-7912030 N133CTValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 31-7912118 N135PBD&R Holdings LLC · Kailua, HIS/N 31-7952035 N135TWValiair Lc Trustee · Casper, WYS/N 31-7852001 N137JHFlatspin LLC · Belle Chasse, LABuilt 1981 · S/N 31-8252025 N138RA & K Aviation LLC · Wenatchee, WABuilt 1972 · S/N 317300935 N139CSCheyenne Flight Group LLC · Wallingford, CTS/N 31T-8120004 N13ALNorthstar Holdings LLC · Anchorage, AKBuilt 1976 · S/N 31-7752009 N13CAAeroclub Management LLC · Cincinnati, OHBuilt 1974 · S/N 31-7405411 N13ESCsl Holdings LLC · Drayton, NDBuilt 1977 · S/N 31-7812046 N140RDAlpha Whiskey 3 LLC · Brandon, MSBuilt 1975 · S/N 31-7552051 N141MEFox Heather J · Bettles Field, AKBuilt 1981 · S/N 31-8152117 N144ASValiair Lc Trustee · Casper, WYBuilt 1973 · S/N 31-7300903 N146DCAztec Worldwide Airlines Inc · Wilmington, DES/N 31-7305109 N146JMarc Inc · Bolton, MSBuilt 1977 · S/N 31-7852005 N1470BBerger Leo · Nampa, IDS/N 31-7512061 N14APGlobal Air Concepts LLC · Anchorage, AKBuilt 1977 · S/N 31-7752060 N14TNGonzalez-Ruiz Antonio R · Mountain Brk, ALBuilt 1981 · S/N 31T-8120060 N151STWildman Lake Lodge Inc · Anchorage, AKBuilt 1979 · S/N 31-8052036 N154CAFedair Inc · Indianapolis, INBuilt 1980 · S/N 31T-8020085 N154WWAlpha Whiskey 1 LLC · Brandon, MSS/N 31-7952230 N155MCWhite Bay Aviation LLC · Corpus Christi, TXBuilt 1978 · S/N 31T-7820069 N158JDNavajo N158jd LLC · Wilmington, DEBuilt 1981 · S/N 318152104 N159DSynapse USA LLC · Mesa, AZBuilt 1974 · S/N 31P7530012 N165TTMakushin Logistics LLC · Fairbanks, AKS/N 318452005 N16SCWestern Alaska Aircraft Leasing LLC · Pahrump, NVBuilt 1970 · S/N 31-639 N16YPSebastian Aero Services Inc · Guaynabo, PRBuilt 1982 · S/N 31-8252008 N171JPCentral Virginia Aviation Inc · North Dinwiddie, VAS/N 31T-7720028 N178SGTango Tango LLC · Naples, FLS/N 31T-8020044 N179RMRaven Air LLC · Coral Gables, FLBuilt 1979 · S/N 31-7912074 N17PSNorris C · Land O Lakes, FLBuilt 1976 · S/N 31P-7630008 N181DCAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedS/N 31T-7520026 N186GADavis Aviation Inc DBA · Brandon, MSS/N 31T-7820086 N1872EAmerican Valet Air Inc · Wilmington, DEBuilt 1980 · S/N 31-8052114 N1872HDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 31-7652053 N189SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 31-7512045 N18HLBusinessliner Inc · Ft Lauderdale, FLBuilt 1980 · S/N 31-8052055 N18RLAlpha Whiskey 3 LLC · Brandon, MSBuilt 1979 · S/N 31-7952090 N191AMInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 31P-7630012 N192CSDodson International Parts Inc · Rantoul, KSBuilt 1973 · S/N 31P-7300138 N195AAAir Travel Management LLC · Lemont Furnace, PABuilt 1978 · S/N 31T7904001 N196AGMarc Inc · Bolton, MSS/N 31-7952036 N1976JLock Haven Aircraft Sales · Lock Haven, PABuilt 1974 · S/N 31T-7520005 N19CBCirrus Flying Professionals LLC · Hollywood, FLS/N 31-7752012 N1ATAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1974 · S/N 31-7405478 N200P10x Aviation Partners LLC · Stuart, FLBuilt 1980 · S/N 31-8052124 N200PGPanther Enterprises LLC · Fort Myers, FLBuilt 1979 · S/N 31T-7920015 N200PVPrestwick Chase Inc · Saratoga Springs, NYBuilt 1971 · S/N 31P-64

Back to AD 96-24-13