Registered aircraft · 6,035

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:2005-05-53-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:2005-05-53-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:2005-05-53-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:2005-05-53-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:2005-05-53-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:2005-05-53-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.

N197MEPremier Air Of Delaware Inc · Flemington, NJBuilt 2000 · S/N 172S8472 N197TACoast Aviation LLC · Costa Mesa, CABuilt 2002 · S/N 172S9197 N1982KN1982k LLC · Wilmington, DEBuilt 2005 · S/N T18208442 N1986VSpeer 182 LLC · Kalispell, MTBuilt 2005 · S/N T18208443 N198BWFixed Wing Holding Co Inc · Pembroke Pines, FLS/N 17280382 N198MECal Aggie Flying Farmers · Davis, CABuilt 2000 · S/N 172S8473 N198PGSun City Aviation LLC · Davie, FLBuilt 2001 · S/N 172S8851 N198SPFlight Training Aircraft LLC · Wilmington, DEBuilt 2003 · S/N 172S9465 N198THWingsleasing LLC · Wichita, KSBuilt 2015 · S/N 172S11554 N1992DRiggan Russell C · Kirkwood, MOBuilt 2005 · S/N 18281716 N1995BN2jz LLC · Amarillo, TXBuilt 2005 · S/N 18281697 N1998FSpartan Education Group LLC · Tulsa, OKBuilt 1998 · S/N 17280347 N1998RA & E Flying Club Of Los Angeles Inc · Hawthorne, CABuilt 1998 · S/N 17280389 N199CACapital Holdings 109 LLC · Potomac, MDBuilt 2005 · S/N 18281548 N199SHPrecision Design Inc · Wilmington, DEBuilt 2008 · S/N 18282078 N199SPW Air LLC · Wheeling, ILBuilt 2003 · S/N 172S9467 N19CMRedrock Aviation LLC · Missoula, MTBuilt 2011 · S/N T18209020 N19DKRichardson Cotton Inc · Wilmington, DEBuilt 2015 · S/N 18282374 N19HPState Of Ohio Dept Of Public Safety · Columbus, OHBuilt 2003 · S/N 18281266 N19KHVan Bortel Aircraft Inc · Arlington, TXS/N 18282073 N19MVSky Path Aviation LLC · Sheridan, WYBuilt 2019 · S/N 172S12273 N19SCSacred Heart Medical Group Inc · Riverside, CABuilt 2001 · S/N T18208101 N1FRApex Aero LLC · Kalispell, MTS/N T18208002 N2000CTextron Aviation Inc · Wichita, KSS/N 172S13601 N2002FTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283349 N2004UEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13449 N20067Epic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13448 N2006PKnox Timothy A · Tulsa, OKBuilt 2005 · S/N 18281684 N2007VCompass Rose Aviation LLC · Derby, KSBuilt 2026 · S/N 18283338 N2007XEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13447 N20126Papa Whiskey Enterprises LLC · Merrimack, NHBuilt 2001 · S/N 18280951 N2012FEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13452 N2012YLake Robert P · Fruita, COBuilt 2006 · S/N 18281770 N2013WEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13451 N2014SGaige Gerald · Gassville, ARBuilt 2006 · S/N 18281772 N2016FEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13450 N201ELAa-Aero LLC · Lewes, DEBuilt 2026 · S/N 172S13545 N201FSRegistration Pending · Peoria, AZRegistration pendingBuilt 2000 · S/N 172S8453 N201KSKing Aircraft LLC · San Diego, CABuilt 2019 · S/N 172S12251 N201THG & M Aircraft Inc · Wheat Ridge, COBuilt 1997 · S/N 17280201 N201TWTom Wood Aviation Inc · Fishers, INBuilt 2025 · S/N 172S13294 N201WLRegistration Pending · Wichita, KSRegistration pendingBuilt 2026 · S/N 172S13570 N2020CN2020c LLC · Abilene, TXBuilt 2005 · S/N 18281700 N2027PHake Equipment Leasing LLC · Farmington Hills, MIBuilt 2005 · S/N 18281724 N2028BWeber Richard · Mountain View, CAS/N 18280952 N202AJEnterprise Aviation Services LLC · Albuquerque, NMBuilt 2007 · S/N 172S10450 N202CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12334 N202SPColorado State Patrol · Denver, COBuilt 2011 · S/N T18209049 N2030CSky Bear LLC · Lakewood, CABuilt 2005 · S/N 172S9941 N203CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12501

Back to AD 2005-05-53 R1