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.

N896AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13542 N896CPCivil Air Patrol · Maxwell Afb, ALS/N 18282394 N897AFAmeriflyers Of Texas Inc · Addison, TXS/N 172S13543 N897CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282395 N897EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12689 N897LPMarcus Air LLC · Plano, TXBuilt 2001 · S/N 172S8897 N897SMDomich Jeffrey E · Petaluma, CABuilt 2011 · S/N 18282309 N898MXHicks Jeff D · Caldwell, IDBuilt 2006 · S/N T18208507 N899AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2016 · S/N 172S11767 N899CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281866 N899JHMickle Aviation Inc Trustee · Wilmington, DEBuilt 2021 · S/N 18283134 N899JRAb Prop Plane II LLC · Metairie, LABuilt 2021 · S/N 172S12708 N89LUTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13585 N8EMHaase Robert F · Vienna, VABuilt 2011 · S/N T18209042 N8PRegistered aircraftBuilt 2025 · S/N T18209179 N8WHGarrett Ag Equipment Ltd · Danbury, TXBuilt 2004 · S/N 18281499 N9004WMustang Sally Aviation LLC · Camden, SCBuilt 2010 · S/N 172S11047 N9005RBeneat John · Georgetown, TXBuilt 2010 · S/N 18282224 N9008HTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2011 · S/N 18282227 N900CAAtp Aircraft 1 LLC · Wilmington, DEBuilt 1997 · S/N 17280114 N900KKSpears Aerial Crop Care LLC · Mamou, LABuilt 2005 · S/N T18208401 N900NFPetros LLC · Bend, ORS/N T18208494 N9010KMitchell Richard · Voorhees, NJBuilt 2024 · S/N 18283285 N901CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8326 N901RMBusey Technology Company LLC · Vienna, VAS/N 18282285 N9022HTurner Kent B · Addison, TXBuilt 2010 · S/N 18282254 N9027CElizabeth City State University · Elizabeth City, NCBuilt 2010 · S/N 172S11069 N902EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12964 N9036BVan Bortel Aircraft Inc · Arlington, TXBuilt 2010 · S/N 18282258 N90391Meyer Florence Trustee · Billings, MTBuilt 2010 · S/N 18282259 N903CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8327 N90404Liberty University · Lynchburg, VABuilt 2010 · S/N 172S11064 N9045BEhg Flight LLC · Venice, CABuilt 2010 · S/N 172S11057 N904CPAbove And Beyond Aviation LLC · Austin, TXBuilt 1999 · S/N 172S8328 N904DRSo Cal Leasing LLC · El Cajon, CABuilt 2004 · S/N 172S9698 N90508Liberty University · Lynchburg, VABuilt 2011 · S/N 172S11073 N9056KOn Time Aviation Corp · Roseland, NJBuilt 2017 · S/N 172S12064 N905CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8329 N905EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12967 N905JANoland Dennis · Modesto, CABuilt 2008 · S/N T18208905 N906CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8910 N906DGExpensive Hobby LLC · Whitehouse Station, NJBuilt 2005 · S/N T18208468 N906JJetran LLC · Horseshoe Bay, TXBuilt 2021 · S/N 18283160 N906JHTop Gun Aviation LLC · Pasadena, MDBuilt 2025 · S/N 18283303 N906JRAmeriflyers Of Texas Inc · Addison, TXBuilt 2006 · S/N 172S10231 N906TMRkt Productions · Bristow, VAFirst renewal noticeBuilt 2010 · S/N 18282269 N907CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8330 N907EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12916 N907JWPalm Beach Flight Training Corp · Lantana, FLBuilt 2006 · S/N 172S10328 N907LPMicro Publishing Press Inc · Truckee, CABuilt 1999 · S/N 172S8221

Back to AD 2005-05-53 R1