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.

N296PLAerospring Leasing LLC · Wasilla, AKBuilt 2025 · S/N 172S13324 N297BBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 2023 · S/N 172S12962 N297CPChristiansen Aviation LLC · Wilmington, DEBuilt 2020 · S/N 172S12503 N297MET L B Inc · Howell, NJBuilt 2000 · S/N 172S8556 N297PEPhoenix East Aviation LLC · Daytona, FLBuilt 2006 · S/N 172S10338 N297PLAerospring Leasing LLC · Wasilla, AKBuilt 2025 · S/N 172S13328 N297TCMoody Bible Institute Of Chicago · Spokane Valley, WABuilt 1997 · S/N 17280016 N298CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283020 N298DBButler John P · Hazelhurst, WIBuilt 2005 · S/N 18281595 N298MCJ C B Aircraft Sales And Leasing · Princeton, NJBuilt 1997 · S/N 17280303 N298MEVermont Flight Academy Inc · South Burlington, VTBuilt 2000 · S/N 172S8557 N298PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10147 N298PLTextron Aviation Inc · Wichita, KSS/N 172S13653 N298SCCharlie Aviation LLC · Oregon City, ORBuilt 2024 · S/N 172S13241 N299CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T18209199 N299KJN299kj LLC · Auburn, WABuilt 2016 · S/N 172S11749 N299PLTextron Aviation Inc · Wichita, KSS/N 172S13654 N29AFDale Michael · Murrieta, CABuilt 1998 · S/N 17280456 N29HTTrede 2023 LLC · Aurora, ORBuilt 2024 · S/N 172S13215 N300KXAtp Aircraft 2 LLC · Wilmington, DEBuilt 2015 · S/N 172S11607 N301CFSunrise Aviation Inc · Ormond Beach, FLBuilt 2002 · S/N 17281135 N302AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281190 N302CFEastern Kentucky University · Richmond, KYBuilt 2002 · S/N 17281137 N302MPKqm Aviation · Bristow, VABuilt 2010 · S/N 18282273 N302TXCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13221 N3033LDaniel Gary · Fallston, MDBuilt 2008 · S/N 18282109 N303EHNavigation Leasing LLC · Keizer, ORBuilt 2023 · S/N 172S13058 N303KATjs3 Aviation LLC · Wilmington, DEBuilt 2013 · S/N T18209094 N303RHNavigation Leasing LLC · Kaizer, ORBuilt 2022 · S/N 172S12926 N303SFSnohomish Flying Service Inc · Snohomish, WABuilt 2025 · S/N 172S13478 N303STVolar Vii LLC · Edmond, OKBuilt 2012 · S/N 172S11242 N304CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283267 N304CGVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 18281609 N304CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12511 N305CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11532 N305FGRidgeline Assets LLC · Wilmington, DES/N 172S13274 N305JRHarrison Aviation LLC · Salem, ORBuilt 2005 · S/N 18281692 N305RCWashington State Patrol · Olympia, WABuilt 2001 · S/N 18281001 N305RSElite Approach LLC · Chesterfield, MOBuilt 2001 · S/N 172S8834 N305TXCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13227 N3064CN3064c LLC · San Tan Valley, AZBuilt 2012 · S/N T18209084 N306CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13082 N306DPHer Airway LLC · Boca Grande, FLBuilt 2016 · S/N 172S11736 N306HBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 2023 · S/N 172S12968 N306PPSl Aviation LLC · Seattle, WABuilt 2010 · S/N 172S11042 N307BZSummit Aviation Inc · Belgrade, MTBuilt 2003 · S/N 172S9486 N308CLRodoni William · Santa Cruz, CABuilt 2008 · S/N T18208825 N308NRState Of Wisconsin · Madison, WIBuilt 2024 · S/N 18283262 N308SPAmeriflyers Of Texas Inc · Addison, TXBuilt 2003 · S/N 172S9487 N309BRValdosta Flying Service Inc · Valdosta, GABuilt 1999 · S/N 172S8101

Back to AD 2005-05-53 R1