Registered aircraft · 11,797

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:2006-16-18-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1') 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:2006-16-18-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1')
  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:2006-16-18-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1')
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.

N123TWGrandy Boyd · Smoot, WYBuilt 1974 · S/N E-518 N123USLow Gary Mike · Southside, ARBuilt 1982 · S/N TH-1335 N123WBHighview LLC · Brentwood, TNBuilt 1978 · S/N TH-937 N1242YSkydive Baltimore LLC · Lincoln, DEBuilt 2002 · S/N 208B0939 N124BGAdvance Jets LLC · Cincinnati, OHBuilt 1999 · S/N 525-0345 N124CMSolomon Mark Trustee · Wilmington, DEBuilt 1984 · S/N FA-24 N124EBPremium Air LLC · Hibbing, MNBuilt 1995 · S/N FL-126 N124GADriscoll Health Care Services · Corpus Christi, TXBuilt 1982 · S/N BB-1039 N124HBVanguard Aircraft Trust Company LLC Trustee · Fort Lauderdale, FLBuilt 1996 · S/N 650-7067 N124KTGams Air LLC · Doral, FLBuilt 1976 · S/N BB-124 N124LCBucks Air Charters Inc · Wilmington, DEBuilt 1980 · S/N E-1684 N124RFRandigo LLC · Wilmington, DEBuilt 1988 · S/N 20800018 N124RSHenley Charles D · New London, NCBuilt 1947 · S/N D-1212 N124TJAlan Aviation LLC · Los Angeles, CAS/N TH-923 N124TMUniversal Aviation LLC · Decatur, ARS/N 421C-0898 N124UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0808 N124WRH.A.I. Services Inc · Justin, TXBuilt 1980 · S/N BB-664 N1252DAeroelite Aviation LLC · Columbia, MOBuilt 1983 · S/N 551-0476 N1253VBane Patricia L · Midland, TXBuilt 2001 · S/N FL-330 N1253WWorthington Enterprises Inc · Columbus, OHBuilt 2012 · S/N FL-790 N1256PPlanemasters Ltd · West Chicago, ILBuilt 1996 · S/N 208B0564 N1258BSouthern Airways Pacific LLC · Addison, TXBuilt 2007 · S/N 208B1258 N1259KN1259k LLC · Youngstown, NYS/N 208B0974 N125BEGomez Eliud · Winter Park, FLS/N TH-43 N125BKColoramo Federal Credit Union · Grand Junction, COBuilt 1982 · S/N BB-977 N125DWMcis Aviation LLC · Wilmington, DEBuilt 2021 · S/N 525-1095 N125EAWestern Dakota Holding Company · Timber Lake, SDBuilt 1979 · S/N 501-0125 N125KAAirmax LLC · Lancaster, SCS/N FL-1125 N125NJAircraft Partner Holdings Inc Trustee · Fallbrook, CABuilt 1982 · S/N LJ-1045 N125RFRandigo LLC · Wilmington, DEBuilt 2012 · S/N 208B2330 N125SBBay Venture Management LLC · Atlanta, GABuilt 1985 · S/N 258046 N125TECj Brown Express LLC · Graettinger, IABuilt 1992 · S/N BB-1422 N125TNTriad Aviation LLC · Tyler, TXBuilt 1993 · S/N 650-7025 N125TSDouble J Aviation Inc · Klamath Falls, ORBuilt 2007 · S/N BB-1993 N125UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0809 N125XPN125xp LLC · Wilmington, DEBuilt 2000 · S/N 258485 N12666Wdr Inc · Grand Forks, NDBuilt 1996 · S/N 20800250 N126ESCobra Aviation Services LLC · Oklahoma City, OKBuilt 2018 · S/N 208B5315 N126GLN126gl LLC · Roca, NEBuilt 1975 · S/N E-763 N126JHM&P Aviation LLC · Lakeland, TNBuilt 1980 · S/N BB-595 N126KLAircraft Fidelity Corp Trustee · Dover, DEBuilt 1984 · S/N 096 N126MCSkyline Aviation Services LLC · Miramar, FLBuilt 1997 · S/N FL-183 N126MMFreeman Holdings Of West Texas LLC · Medford, ORBuilt 2002 · S/N LJ-1669 N126RFRandigo LLC · Wilmington, DEBuilt 2005 · S/N 208B1156 N126UPC C & E I LLC · Louisville, KYBuilt 2000 · S/N 0810 N126WAJpg & Aog LLC · Concord, NCBuilt 1984 · S/N LJ1093 N1276YJet Rider LLC · Middletown, DEBuilt 2005 · S/N 208B1113 N127ARAircraft Unlimited Inc · Pierre, SDBuilt 2004 · S/N 208B1055 N127GABeech Transportation Inc · Eden Prairie, MNBuilt 1977 · S/N BB312 N127GKAlliance Aviation Group LLC · Wilmington, DES/N 311

Back to AD 2006-16-18 R1