Registered aircraft · 3,462

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

N211GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-211 N211MAvp Aviation LLC · Indianapolis, INBuilt 2017 · S/N 100-0211 N2126TTidwell Sprayers Inc · Dimmitt, TXBuilt 1998 · S/N T15-038 N212DTThiel Aircare Inc · Chowchilla, CABuilt 2005 · S/N 802A-0212 N212HBBritt Christopher Charles · Bryan, TXBuilt 1982 · S/N 31214 N212HPCorpat Inc · Missoula, MTBuilt 1979 · S/N 30951 N212LWPf Aviation LLC · Carl Junction, MOBuilt 2001 · S/N BB-1766 N212PKOc Aviation LLC · Victoria, TXBuilt 2005 · S/N 668 N212YS76b LLC · New York, NYBuilt 1989 · S/N 760357 N213BHBighorn Flying Co LLC · Wood River, NEBuilt 2013 · S/N 402B-1279 N213DBMarshall Air Systems Inc · Charlotte, NCBuilt 1993 · S/N BB-1450 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 N2157CNational Test Pilot School · Mojave, CABuilt 1983 · S/N 005 N215SDEastern Stearman Inc Trustee · Leesburg, VABuilt 2001 · S/N 4697049 N216CSAlpine Aviation Inc · Provo, UTBuilt 1983 · S/N U-216 N216KQState Of Washington · Olympia, WABuilt 2017 · S/N 100-0216 N216PKTecumseh Skydiving School LLC · Jackson, MIBuilt 2005 · S/N 114 N217EBRapids Camp Lodge Inc · King Salmon, AKFirst renewal noticeBuilt 1996 · S/N 154 N2185MFreefall Express · Gardiner, NYBuilt 1968 · S/N 687 N218PAPreferred Airparts LLC · Kidron, OHS/N 20800384 N219TMPikeville Premier Aero LLC · Pikeville, KYBuilt 2007 · S/N LJ-1828 N219WWTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1975 · S/N B-219 N21AUBoeing Co · Renton, WABuilt 2005 · S/N 606 N21FGCalifornia Department Of Fish And Game · Sacramento, CABuilt 1981 · S/N BB-839 N220GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-220 N220MARegistration Pending · Chestertown, MDRegistration pendingBuilt 2002 · S/N 248 N220QKBridger Aviation Services LLC · Belgrade, MTBuilt 2017 · S/N 100-0220 N220TTShannair LLC · Saint Louis, MOS/N BB-462 N220UM3k Aviation LLC · Birmingham, MIBuilt 2004 · S/N 4697183 N221BHUas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-168 N221BNSkyhi Aero LLC · Jasper, TNBuilt 2010 · S/N 165 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 N222HHJenntoo LLC · Wilmington, DEBuilt 2022 · S/N 100-0314 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 N223QKRovey Jason · Wickenburg, AZBuilt 2017 · S/N 100-0223 N2243JR & S Aviation LLC · Corning, ARBuilt 1996 · S/N T41-221

Back to AD 2002-23-13