Registered aircraft · 6,038

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.

N362KTOverstreet Investments Inc · Boonville, MOBuilt 2018 · S/N 18283043 N362LULewis University · Romeoville, ILBuilt 2023 · S/N 172S12983 N362QRegistered aircraftBuilt 2018 · S/N 172S12188 N362SPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2001 · S/N 172S8779 N3635S2nd Chance Enterprise LLC · North Haledon, NJBuilt 2002 · S/N T18208179 N363BLElizabeth City State University · Elizabeth City, NCBuilt 2004 · S/N 172S9741 N363CKAviator Air Operations LLC · Grand Prairie, TXBuilt 2004 · S/N 172S9634 N363CPBarr Air Patrol LLC · Mesquite, TXBuilt 2000 · S/N 172S8382 N363CS3tr Aviation LLC · Longview, TXBuilt 2022 · S/N 18283163 N363KRegistered aircraftBuilt 2018 · S/N 172S12195 N363MAMuchodeanaero Inc · Wilmington, DEBuilt 1998 · S/N 172S8006 N363SAN363sa LLC · Stuart, FLS/N 17280756 N363SPOrange County Flight Center Inc · Santa Ana, CABuilt 2001 · S/N 172S8781 N364CPBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 172S8803 N364DRegistered aircraftBuilt 2014 · S/N 172S11373 N364GWHdh Aircraft Leasing LLC · Carrollton, TXBuilt 2003 · S/N 172S9364 N364MAJet Air Inc · Iowa City, IABuilt 1998 · S/N 172S8007 N364MSSkyhawk Aviation LLC · Omaha, NEBuilt 1997 · S/N 17280015 N364SAJackson Edwin W · Tampa, FLBuilt 1999 · S/N 17280757 N364SPVermont Flight Academy · South Burlington, VTBuilt 2001 · S/N 172S8782 N365CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282117 N365CPBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 172S8838 N365ESLakewood Investments LLC · Victorville, CABuilt 1997 · S/N 17280023 N365SPClow International Airport LLC · Bolingbrook, ILBuilt 2001 · S/N 172S8783 N365WCCrane Douglas F · Ukiah, CABuilt 2002 · S/N 18281170 N366CTAia Charlie LLC · Henderson, NVBuilt 2025 · S/N 172S13341 N366NHState Of New Hampshire Dept Of Safety · Concord, NHBuilt 2008 · S/N 18282106 N366STN366st LLC · Kenesaw, GABuilt 2025 · S/N 172S13331 N367CTCoast Flight Training And Management Inc · San Diego, CABuilt 2008 · S/N 172S10711 N367MAMindy Limited LLC · Muscatine, IABuilt 1998 · S/N 17280649 N367TWTextron Aviation Inc · Wichita, KSS/N 172S13607 N368ESMindy Limited LLC · Muscatine, IABuilt 1997 · S/N 17280022 N369CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12346 N369DADuan Ran · Bothell, WABuilt 2023 · S/N 172S13041 N369GCCoyote Moon Ranch LLC · Otsego, MIBuilt 2025 · S/N T18209187 N369TCSchach Barbara G · Kirkland, WABuilt 2001 · S/N T18208052 N369TWChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9063 N369WPLego Aviation LLC · Grimes, IABuilt 2025 · S/N 18283327 N36ADTextron Aviation Inc · Wichita, KSS/N T18209210 N36JRCatching Freedom LLC · Bozeman, MTS/N 172S11204 N36TPEichenour Daniel L · Willis, TXBuilt 2005 · S/N T18208387 N370CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18282000 N370ESPerformance Aircraft Sales Inc · Lincoln, NEBuilt 1997 · S/N 17280029 N370JHNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282191 N370K370k LLC · Bethany, OKBuilt 2026 · S/N 172S13481 N370SPElite Approach LLC · Chesterfield, MOBuilt 2003 · S/N 172S9501 N371CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18282001 N371RHChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10414 N372AFFlyslow Aviation LLC · Sterling, VABuilt 2003 · S/N 18281191 N372AHRegier Tom · Dinuba, CABuilt 2006 · S/N 172S10156

Back to AD 2005-05-53 R1