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.

N848CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281851 N848EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12803 N848FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13459 N848KSKansas State University · Salina, KSBuilt 2022 · S/N 172S12831 N848PAChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12272 N849CFEllison David B · Spotsylvania, VABuilt 2002 · S/N T18208149 N849CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281852 N849KBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 2023 · S/N 172S12960 N849KSKansas State University · Salina, KSBuilt 2022 · S/N 172S12839 N849PAChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12274 N84RJM & G Aircraft Management LLC · Aurora, ORBuilt 2023 · S/N 172S13061 N84SHAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13266 N84WAFlying High LLC · Selah, WAS/N T18208425 N84WEVan Bortel Aircraft Inc · Arlington, TXBuilt 2010 · S/N T18208999 N850FGMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10376 N850SPAviolease LLC · Vancouver, WABuilt 2001 · S/N 172S8758 N851CBTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2024 · S/N 172S13180 N851CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12721 N851DSClark Robert E IV · Port Aransas, TXS/N T18208241 N851EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13196 N851SPLegends Air Center LLC · Bentonville, ARS/N 172S8759 N851TAHarrell & Assoc An Accountancy Corp · Santa Ana, CABuilt 2002 · S/N T18208151 N852CPPmbarrett Aviation LLC · Tucson, AZBuilt 1998 · S/N 17280485 N852EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13225 N852PAChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12275 N853CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281853 N853PADk Skyhawk LLC · Fulshear, TXBuilt 2019 · S/N 172S12286 N854AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13536 N854CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282202 N854DZHohnadel R Michael · Harlingen, TXBuilt 2002 · S/N 18281150 N854EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13228 N854GWCondair Flyers Inc · Latham, NYBuilt 2001 · S/N 172S8854 N854SCAlpha Charlie Aviation LLC · Keizer, ORBuilt 2019 · S/N 172S12329 N854TCBeech Construction Inc · Pittsburgh, PABuilt 2005 · S/N T18208364 N855CPVector Air LLC · Erie, COBuilt 1998 · S/N 17280461 N855EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13231 N856AUAuburn University · Auburn, ALBuilt 2017 · S/N 172S12094 N856CSWendorf Bruce L · North Fort Myers, FLBuilt 2015 · S/N 18282397 N856DKGlobal Aircraft Solutions LLC Trustee · Newark, DES/N T18208439 N856EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12674 N856FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13460 N857AUAuburn University · Auburn, ALBuilt 2018 · S/N 172S12126 N857NTSmeltz Kent · Dornsife, PABuilt 2018 · S/N 18283059 N857SPSoutheastern Oklahoma State University · Durant, OKS/N 172S8115 N858AUAb Prop Plane II LLC · Metairie, LABuilt 2018 · S/N 172S12149 N858CPDae Aviation Enterprises Corp · Gilford, NHBuilt 1998 · S/N 17280539 N858RDTextron Aviation Inc · Wichita, KSS/N T18209211 N858VKChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12263 N858WKChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12264 N858XJChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12265

Back to AD 2005-05-53 R1