Registered aircraft · 479

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:2005-12-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:2005-12-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:2005-12-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:2005-12-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:2005-12-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:2005-12-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.

N385CAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0111 N38CJAirplane Seven LLC · Watkins, COBuilt 1978 · S/N 402C0023 N38GJMonahan Jeffrey L Trustee · Long Beach, CABuilt 1982 · S/N 414A0829 N400ATAlpha Tango Aviation Inc · Middletown, DEBuilt 1981 · S/N 402C0510 N400FCCrosswind Enterprises LLC · Box Elder, SDS/N 414A0023 N401SXHyannis Air Service Inc · Hyannis, MAS/N 402C0447 N401TJHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0109 N402BKN402bk LLC · Nantucket, MABuilt 1978 · S/N 402C0689 N402HGHyannis Air Service Inc DBA · Hyannis, MABuilt 1985 · S/N 402C1016 N402JHAir Flight Inc · Fort Lauderdale, FLBuilt 1980 · S/N 402C0500 N402RSTropical Transport Services Ltd · San Jaun, PRBuilt 1980 · S/N 402C0402 N402SAAlly Mohamed Yacoob · Fort Lauderdale, FLS/N 402C0623 N402SBGlemone Airways Inc · Wilmington, DEBuilt 1979 · S/N 402C0082 N402VNHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0488 N402VPVespa Power Products LLC · Visalia, CAFirst renewal noticeS/N 402C0025 N402ZKAirplane One LLC · Miami Springs, FLBuilt 1981 · S/N 402C0028 N404DGSubgup LLC · Naples, FLS/N 414A0111 N404NSJ + D Aviation Services LLC · Centerville, MABuilt 1980 · S/N 402C0421 N404PJPrivate Jet LLC · Miami Springs, FLBuilt 1981 · S/N 402C0513 N4057CAberdeen Flying Service · Aberdeen, SDBuilt 1982 · S/N 414A0848 N406BKN406bk LLC · Nantucket, MABuilt 1984 · S/N 402C0807 N406GAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0329 N406RCIsland Flights Inc · Wilmington, DEBuilt 1981 · S/N 402C0470 N409BKHyannis Air Service Inc DBA · Hyannis, MABuilt 1982 · S/N 402C0651 N40SKSides Family Management LLC · El Paso, TXBuilt 1979 · S/N 414A0323 N410NFMurphy Aviation Inc · Gilroy, CABuilt 1978 · S/N 414A0102 N411ABAmerican Time Machine LLC · Edmond, OKBuilt 1980 · S/N 414A0524 N411VGMontala Investments LLC · Montgomery, ALBuilt 1981 · S/N 414A0675 N412CAAirswiss Inc · Wilmington, DES/N 402C0005 N413BMLee Aviation LLC · Sheridan, ARBuilt 1977 · S/N 414A0004 N414AKValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 414A0321 N414AMToucan Aviation LLC · Lafayette, LABuilt 1982 · S/N 414A0850 N414ATCreekmore Arnold · Somerset, KYBuilt 1978 · S/N 414A0209 N414AVChoate Oilfield Services LLC · Hennessey, OKS/N 414A0294 N414BTrojan Enterprises LLC · Dover, DES/N 414A0109 N414BBDougherty Forestry Manufacturing Ltd Co · Hinton, OKS/N 414A0839 N414BGGreen Forest Aviation LLC · Edmond, OKBuilt 1978 · S/N 414A0094 N414BLBig South Fork Aero Inc · Huntsville, TNBuilt 1978 · S/N 414A0115 N414BPN414bp LLC · Valley Center, KSS/N 414A0506 N414BRQualitair LLC Trustee · MichelstadtS/N 414A0282 N414BSHunger Relief Ministries · Forney, TXBuilt 1980 · S/N 414A0504 N414BTCmo Blue Sky LLC · Tomball, TXBuilt 1978 · S/N 414A0048 N414BWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1978 · S/N 414A0049 N414CASurgeon LLC · Arcadia, LABuilt 1980 · S/N 414A0479 N414CLL Squared Aviation LLC · Marine, ILBuilt 1977 · S/N 414A0003 N414CMMartin Livestock LLC · Ione, CABuilt 1980 · S/N 414A0472 N414CNAllied Asset Management LLC · Oklahoma City, OKBuilt 1978 · S/N 414A0035 N414CSCareflight Logistics LLC · Bingham Farms, MIS/N 414A0230 N414CWCrosswind Media LLC · Terrell, TXBuilt 1979 · S/N 414A0329 N414DDModern Custom Design LLC · Melbourne Beach, FLBuilt 1979 · S/N 414A0245

Back to AD 2005-12-13