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.

N212HPCorpat Inc · Missoula, MTBuilt 1979 · S/N 30951 N212YS76b LLC · New York, NYBuilt 1989 · S/N 760357 N213DBMarshall Air Systems Inc · Charlotte, NCBuilt 1993 · S/N BB-1450 N213LAJet Rider LLC · Middletown, DEBuilt 2004 · S/N 208B1096 N213MCMcr Aviation LLC · Austin, TXBuilt 1991 · S/N FA-216 N213REWhital Enterprises LLC · Dover, DEBuilt 2002 · S/N 230 N214GBPterodactyl Inc · Wilmington, DEBuilt 1999 · S/N BB-1668 N214NXLife Flight Network LLC · Aurora, ORBuilt 2010 · S/N 1214 N214PNavajo Nation · Window Rock, AZBuilt 1991 · S/N LJ-1293 N214SCAzul Air LLC · Dover, DEBuilt 1976 · S/N LW-96 N215BTScreen Star Inc Trustee · Wilmington, DEBuilt 2009 · S/N 20800517 N215MCTatonduk Outfitters Ltd DBA · Fairbanks, AKBuilt 1999 · S/N 208B0730 N215SDEastern Stearman Inc Trustee · Leesburg, VABuilt 2001 · S/N 4697049 N215TXTexas Dept Of Public Safety · Austin, TXBuilt 2012 · S/N 20800542 N216CSAlpine Aviation Inc · Provo, UTBuilt 1983 · S/N U-216 N216RFRandigo LLC · Wilmington, DEBuilt 1993 · S/N 208B0379 N217EBRapids Camp Lodge Inc · King Salmon, AKBuilt 1996 · S/N 154 N2185MFreefall Express · Gardiner, NYBuilt 1968 · S/N 687 N218PAPreferred Airparts LLC · Kidron, OHS/N 20800384 N21AUBoeing Co · Renton, WABuilt 2005 · S/N 606 N21FGCalifornia Department Of Fish And Game · Sacramento, CABuilt 1981 · S/N BB-839 N220TTShannair LLC · Saint Louis, MOS/N BB-462 N220UM3k Aviation LLC · Birmingham, MIBuilt 2004 · S/N 4697183 N220XWMartinaire Aviation LLC · Addison, TXBuilt 2000 · S/N 208B0822 N221BHUas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-168 N221GSendero Aviation Services LLC · Dublin, TXBuilt 1998 · S/N FL-198 N221JDPerrydise Aviation LLC · Tulsa, OKBuilt 1991 · S/N 1010 N222CMBriar Lakes Productions Inc · Palestine, TXBuilt 1995 · S/N 111 N222CYBlue Star Gas Fleet Services Co · Santa Rosa, CABuilt 1990 · S/N BB-1370 N222PVJ Turbines Inc · Wilmington, DEBuilt 1997 · S/N FL167 N222RLTalon Air Service Inc · Soldotna, AKBuilt 1964 · S/N 1570 N2239BBeery Milo A · Clarinda, IAS/N T41-217 N223ALWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N 223 N223CABemidji Aviation Services Inc · Bemidji, MNBuilt 1983 · S/N U-200 N223EARegal Air Partners I LLC · New Iberia, LABuilt 2005 · S/N 323 N223LHLelah Holdings Limited Partnership · Reno, NVBuilt 1976 · S/N B-223 N2243JR & S Aviation LLC · Corning, ARBuilt 1996 · S/N T41-221 N224CCRanger Aviation LLC · Houston, TXS/N LJ-1218 N224SAIkhana Aircraft Holdings LLC · Murrieta, CABuilt 1969 · S/N 247 N2251QSabo John W · Spicewood, TXBuilt 1997 · S/N EA-604 N2254LPhoenix Equipment Lc · Nickerson, KSBuilt 1985 · S/N 400-0611 N225CATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N 31T-8104024 N225JCJetcruzer International LLC · Ontario, CABuilt 1997 · S/N 002 N225MAAerial Services Inc · Cedar Falls, IABuilt 2001 · S/N 4697106 N226DRTechnical Education Services Inc · Virginia Beach, VABuilt 1967 · S/N LM-14 N226MDSolomon Aviation LLC · Northumberland, PAS/N 88 N227AVUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U-227 N227DCEllen Vineyards Inc · Sanger, CABuilt 1979 · S/N LJ876 N227GHCarlen Aviation LLC · Wilmington, DEBuilt 2022 · S/N 20800688 N227MFMeragals LLC · Evergreen, COBuilt 2003 · S/N 502

Back to AD 2014-17-08 R1