Registered aircraft · 2,525

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:2014-17-08-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:2014-17-08-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:2014-17-08-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:2014-17-08-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:2014-17-08-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:2014-17-08-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.

N12FAWilke Aviation Group LLC · College Station, TXBuilt 1995 · S/N 117 N12GJBuilding Ideas Inc · Los Gatos, CABuilt 1972 · S/N LW-12 N12LUDonalds Flying Service Inc · Pantego, NCBuilt 1998 · S/N T15-037DC N12XVStormhaul Holding LLC · Taylors, SCBuilt 2021 · S/N 20800678 N1314XWright Air Service Inc · Fairbanks, AKBuilt 2008 · S/N 208B1314 N131GPUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U225 N131RFRandigo LLC · Wilmington, DEBuilt 2000 · S/N 208B-0851 N131SAPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 46020113 N131SJGravitas Aviation LLC · Dallas, TXBuilt 1976 · S/N BB-131 N131SPKauffman Land & Development LLC · Denver, COBuilt 1983 · S/N LA-206 N1323YState Of Alaska · Anchorage, AKBuilt 2001 · S/N 20800352 N1324GProps & Jets Inc · Dover, DEBuilt 1999 · S/N 208B0777 N132KCAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-132 N133GAJab Aire LLC · Wilmington, DEBuilt 1989 · S/N BB1321 N133RFRandigo LLC · Wilmington, DEBuilt 2000 · S/N 208B0840 N134ME D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2003 · S/N 4697169 N1350AAlaska Skypower LLC · Fairbanks, AKBuilt 1944 · S/N 33032 N135CKStellar Aviation LLC · Williamstown, NJBuilt 1999 · S/N 208B0776 N135FLAfdflt LLC · Mount Vernon, ILBuilt 2002 · S/N 4697135 N135LTFleming William D · Litchfield, ILBuilt 1997 · S/N 135 N135RFRandigo LLC · Wilmington, DEBuilt 1996 · S/N 208B0551 N136CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0037 N137BABemidji Aviation Services Inc · Bemidji, MNBuilt 1970 · S/N U137 N138JMFull Throttle Aviation LLC · Clayton, DEBuilt 1991 · S/N 7 N139MCBilly Bobs Flying Service LLC · Bay, ARBuilt 2024 · S/N 510-139 N139SCNew Ulm C90 LLC · Marshall, MNBuilt 1979 · S/N LJ868 N13GXEpic II LLC · Reno, NVBuilt 2023 · S/N K040 N13GZGuardian Flight LLC · South Jordan, UTBuilt 2000 · S/N LJ-1590 N141MHCinema Aircraft Executive Transportation LLC · Las Vegas, NVBuilt 1997 · S/N 760465 N141RFRandigo LLC · Wilmington, DEBuilt 1986 · S/N 20800105 N1421ZMng Leasing LLC · Bottineau, NDBuilt 1998 · S/N 140 N142EEHound Dog Aircraft LLC · Lawrence, KSBuilt 2005 · S/N 4697217 N143ZUsda Forest Service Fire & Aviation · Boise, IDBuilt 1974 · S/N 437 N144CMeyers Construction Inc · Fresno, CABuilt 1991 · S/N FL-49 N144JTFlight 1976 LLC · Kennesaw, GABuilt 1999 · S/N 144 N144KSAas LLC · Ovid, MIBuilt 1986 · S/N 400-0640 N145GPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 20800722 N145KAKamaka Air LLC · Honolulu, HIBuilt 2008 · S/N 208B2019 N145SLCash Depot Ltd · Green Bay, WIBuilt 2004 · S/N 1093 N145WAMartinaire Aviation LLC · Addison, TXBuilt 2005 · S/N 208B1145 N146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1982 · S/N BB1046 N146SLDodson International Parts Inc · Rantoul, KSS/N 1091 N146WMWatermakers Air Inc · Fort Lauderdale, FLBuilt 2000 · S/N 208B-0813 N148SAZuni LLC · Kirkland, WAS/N 409 N149CCCianbro Corp · Baltimore, MDS/N FA-145 N149QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1996 · S/N 149 N149SFAlpine Aviation Inc · Provo, UTBuilt 1991 · S/N UC-149 N14GVScott T LLC · Portland, ORS/N 4697092 N1500EVaughans Aircraft Leasing LLC · Claremore, OKS/N 402-0820 N1502BAeroag LLC · Portland, INBuilt 1998 · S/N 502B-0476

Back to AD 2014-17-08 R1