Registered aircraft · 11,798

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.

N716ESFlorida Fish And Wildlife Conservation Commission · Lakeland, FLBuilt 2023 · S/N 20800694 N716FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0442 N716JFAlexander Aviation LLC · Ellisville, MSBuilt 1977 · S/N E-954 N716MJAlpine Aviation Inc · Provo, UTBuilt 1992 · S/N UE-16 N716MMArne Aviation LLC · Suffolk, VAS/N 208B0746 N716SNsa II LLC · Frankfort, NYBuilt 1998 · S/N 560-0473 N716TAB P Air LLC · Delhi, LAFirst renewal noticeBuilt 1995 · S/N BB-1509 N717AMLopez Fabio · Denver, NCBuilt 1984 · S/N 100 N717BRSemper Fi Aviation LLC · Aledo, TXBuilt 2020 · S/N 525-1055 N717DBlountville Aviation LLC · Blountville, TNBuilt 1994 · S/N 5600275 N717DCAircraft Unlimited Inc · Pierre, SDS/N BB-1261 N717DHDarkhorse Aviation LLC · Georgetown, TXBuilt 1990 · S/N 226 N717EBAmigos Al Dia Pr LLC · Carolina, PRBuilt 1981 · S/N 016 N717ERThomas James V · Cullman, ALBuilt 1985 · S/N TH-1463 N717FDFederal Express Corp · Memphis, TNBuilt 1987 · S/N 361 N717FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0445 N717HBTms Global Investments Inc · Naples, FLBuilt 1982 · S/N 066 N717HPOhio Department Of Public Safety · Columbus, OHBuilt 2024 · S/N 208B5833 N717JGHvl Air · Fresno, CABuilt 1975 · S/N LJ-672 N717KVN717kv LLC · Wilmington, DEBuilt 1999 · S/N 258449 N717LCAircraft Capital Partners LLC · Bozeman, MTBuilt 1992 · S/N UE-17 N717LFOnpoint Avionics LLC · Downey, CAFirst renewal noticeS/N 32 N717LRJnnss LLC · Hillsborough, NJS/N 421C1109 N717MTAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1989 · S/N 258163 N717PAPa1 208b-0804 LLC · Fort Lauderdale, FLBuilt 2000 · S/N 208B0804 N717UGMesoamerica Aviation Corp · Wilmington, DEBuilt 2016 · S/N FL-1066 N717VAAtlanta Air Charter Inc · Kennesaw, GABuilt 2007 · S/N BB-1994 N717VEMcfielden LLC · Midland, TXS/N FL-207 N717VLRebus III LLC · Owasso, OKBuilt 2008 · S/N 560-0788 N717XBanana Hill LLC · Ashland, ORBuilt 1973 · S/N LJ-581 N71885Bank Of Utah Trustee · Salt Lake City, UTS/N FL485 N718FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0448 N718HCAcme Leasing II LLC · Nashville, TNBuilt 1985 · S/N 258040 N718HSWinnlu Aviation LLC · Greenwich, CTS/N E-3462 N718LFJet Geeks Aviation Maintenance Inc · Teterboro, NJS/N 258254 N718RRMac 800xp LLC · Wilmington, DEBuilt 1999 · S/N 258428 N719BHWilliams Farms LLC · Panhandle, TXBuilt 1979 · S/N BB-564 N719FDFederal Express Corp · Memphis, TNBuilt 1989 · S/N 388 N719FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0450 N719HGFlightworks Inc · Kennesaw, GABuilt 2000 · S/N 258488 N719HPWoolpert Inc · Dayton, OHBuilt 2006 · S/N 208B1191 N719PBGraber Joel · Collins, MSBuilt 1973 · S/N LJ-594 N719RM3v LLC · Yalesville, CTBuilt 1991 · S/N 560-0092 N71AHAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2004 · S/N 258654 N71BLLachapelle Brian L · North Palm Beach, FLBuilt 1968 · S/N E-5 N71FBTelling Frederick W · Port Orange, FLFirst renewal noticeBuilt 2013 · S/N 525-0812 N71GRRahmeyer Gary W · Lake Ozark, MOBuilt 1976 · S/N TH784 N71JRSouthgate Development Inc · Wichita Falls, TXBuilt 1976 · S/N 421C0066 N71KACentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1973 · S/N LJ-578 N71KGFarwell Flash Aviation LLC · Farwell, TXFirst renewal noticeBuilt 1980 · S/N 551-0214

Back to AD 2006-16-18 R1