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.

N86BJWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280238 N86PVPvr Construction LLC · Wilmington, DEBuilt 2025 · S/N T18209177 N870CPAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 17280666 N870EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13514 N870PLake Elysian Sky Holdings LLC · Janesville, MNS/N 18281135 N870SPEstern Kentucky University · Richmond, KYBuilt 1999 · S/N 172S8130 N871CPRedstone Arsenal Flying Activity · Redstone, ALBuilt 1999 · S/N 17280687 N871EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13517 N871FBFreebird Leasing Group LLC · Sarasota, FLBuilt 2024 · S/N 18283266 N872EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13520 N872FALewis University · Romeoville, ILBuilt 2002 · S/N 17281109 N872FSTfs Air LLC · Loveland, COBuilt 2003 · S/N 17281172 N872SPChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8134 N873CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281872 N873EFFlorida Flight Training Center · Venice, FLBuilt 2006 · S/N 172S10163 N874EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12680 N874LLLandry Raymond M · Georgetown, TXBuilt 2005 · S/N T18208457 N875CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281871 N875DESoftcomm Aviation Inc · Irvine, CABuilt 2006 · S/N T18208659 N875PJVan Bortel Aircraft Inc · Arlington, TXBuilt 2016 · S/N 18282460 N876EJEvans Ernest Levi Jr · Cary, NCBuilt 2011 · S/N T18209045 N876EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13523 N876MGAb Prop Plane II LLC · Metairie, LABuilt 2021 · S/N 172S12709 N877AAFlx Flyers LLC · Farmington, NYBuilt 2018 · S/N 172S12152 N877CVBrown Joseph Glenn · Desert Hills, AZBuilt 2004 · S/N T18208307 N877DWAviation Concepts LLC · Coeur D Alene, IDBuilt 2001 · S/N T18208073 N8784TElizabeth City State University · Elizabeth City, NCBuilt 2019 · S/N 172S12406 N8789TChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12408 N878CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281868 N878EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12684 N878MSProvidence Flying LLC · Chillicothe, MOBuilt 2007 · S/N T18208715 N878SATampa Bay Aviation Inc · Clearwater, FLBuilt 2006 · S/N 172S10209 N879CPCivil Air Patrol · Maxwell Afb, ALS/N 18282183 N879FZDon Davis Aviation Inc · Henderson, KYBuilt 2019 · S/N 172S12403 N879HZMewmew Investment LLC · Palo Alto, CABuilt 2019 · S/N 172S12405 N879LPSpartan National Holdings LLC · Missoula, MTBuilt 2001 · S/N 172S8879 N879MTCfgn Aviation LLC · Molalla, ORBuilt 1997 · S/N 17280063 N879WMPsl Surveys · Bristow, VABuilt 2010 · S/N 18282216 N87FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12950 N87GVChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280355 N87HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 1998 · S/N 172S8022 N87JAN87ja Lk Aircraft Holdings LLC · Wheeling, ILBuilt 1998 · S/N 172S8012 N880AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13537 N880CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281870 N880EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12807 N880SVDiamond Xport LLC · Rochdale, MABuilt 2025 · S/N T18209194 N880WSDepartment Of Inland Fisheries And Wildlife · Greenville, MEBuilt 2015 · S/N 172S11661 N881ACFly Twin Comanche LLC · Peoria, AZBuilt 2001 · S/N 172S8818 N881LAAircraft Holdings LLC · Mesa, AZBuilt 2020 · S/N 172S12607 N881PAAtomic Partners LLC · Oak Ridge, TNBuilt 2009 · S/N T18208960

Back to AD 2005-05-53 R1