Registered aircraft · 11,794

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.

N118RFRandigo LLC · Wilmington, DEBuilt 1996 · S/N 208B0574 N118RJDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 188 N118RWCitation N118rk LLC · Houston, TXS/N 560-0389 N118SBEaglemed LLC · Wichita, KSBuilt 1996 · S/N BB-1541 N118TBColtman Peter O · Colleyville, TXBuilt 1981 · S/N E-1891 N1191DFas Holdings LLC · Osage Beach, MOBuilt 1986 · S/N TH-1506 N1194AGta Air Inc · Addison, TXBuilt 1969 · S/N E-159 N1195TRoberts Robin W · Birmingham, ALBuilt 1974 · S/N E-629 N119ACKidd Kevin A · Key West, FLBuilt 1972 · S/N TH-188 N119ARCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N BB-1867 N119EDCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1948 · S/N D-1497 N119EWBte Aviation LLC · Wilmington, DEBuilt 1981 · S/N E-1863 N119MCAgave III LLC · Seattle, WABuilt 1985 · S/N BB-1225 N119RFRandigo LLC · Wilmington, DEBuilt 2002 · S/N 208B0929 N119SAInvestment Opportunities Pursuit LLC · Greenville, NCBuilt 1989 · S/N LJ-1196 N119TWCarter Flygare Inc · Sacramento, CABuilt 1974 · S/N TH-533 N11DTAzul Air LLC · Dover, DEBuilt 1972 · S/N LW-11 N11ESale Reported · Wayne, NESale reported, canceledBuilt 1947 · S/N D-699 N11ECBasler Turbo Conversions LLC · Oshkosh, WIBuilt 1970 · S/N TH-128 N11EVBonita Beech LLC · Bonita Springs, FLBuilt 1976 · S/N TH-748 N11LGLima Golf Investments LLC · Bigfork, MTBuilt 1994 · S/N 525-0066 N11LXN492a LLC · Goodyear, AZBuilt 1974 · S/N 306-75 N11SNSsj Holdings LLC · Modesto, CABuilt 1982 · S/N LJ-1036 N11VZLowcountry Flight LLC · Johns Island, SCBuilt 1973 · S/N E-397 N11WBMercier David · Whitefish, MTBuilt 2006 · S/N 525-0616 N11WNRds Aviation LLC · Elkhart, INBuilt 1982 · S/N LA177 N11WPPlacer Aviation LLC · Loomis, CABuilt 1990 · S/N E-2546 N11XMWesley F Walker · Rock Hill, SCBuilt 1999 · S/N E-3225 N11YPDanforth Equipment LLC · Leesburg, FLBuilt 1987 · S/N TH-1509 N1205SCounty Line Aviation LLC · Benton, KSBuilt 1979 · S/N LW-319 N1205Z198gb LLC · Asheboro, NCBuilt 2018 · S/N 525-0985 N1206KOnuzo Chika N · Fayetteville, GAS/N 421C1804 N1206NCapital Group Inc · Garden City, IDBuilt 1985 · S/N 421C1805 N120DBB & I Leasing LLC · Berryville, VABuilt 1978 · S/N E1276 N120JWRedge Air LLC · Jacksonville, FLBuilt 2004 · S/N 258672 N120NCDavis Aviation Inc DBA · Brandon, MSBuilt 1982 · S/N BB1056 N120RPMallory & Evans Aviation LLC · Scottdale, GABuilt 1984 · S/N LJ-1075 N120UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 29166 N120UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0805 N1210LElite Elevated Enterprises LLC · Las Vegas, NVBuilt 1997 · S/N 650-7078 N1212International Air Services Inc Trustee · Carson City, NVBuilt 2012 · S/N FL-803 N1212GNickeson Family LLC · Maquoketa, IABuilt 1988 · S/N E-2418 N1212WTwo Drakes Air LLC · Lizella, GABuilt 1994 · S/N LJ-1381 N1213PL7 Air LLC · Chandler, AZBuilt 2020 · S/N FL-1220 N1213SWright Caravan LLC · Seattle, WABuilt 1995 · S/N 20800243 N12155International Air Services Inc Trustee · Carson City, NVBuilt 1996 · S/N 208B0562 N121AFEway William · Jupiter, FLBuilt 1981 · S/N TH-1254 N121AQPacker William M III Trustee · Orchard Lake, MIS/N 421C1063 N121BArgo Aviation LLC · Potsdam, NYBuilt 1972 · S/N LW-21 N121CMSpace Coast Aircraft Co · Merritt Island, FLBuilt 1993 · S/N 208B0336

Back to AD 2006-16-18 R1