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.

N39BBHammonds Willard H II · Corpus Christi, TXBuilt 2005 · S/N T18208360 N39PDBechard Barry C · Mount Joy, PABuilt 2000 · S/N 172S8424 N3YUT2 Aviation LLC · Missouri City, TXBuilt 2004 · S/N 18281453 N4000XJp Skyward LLC · Ontario, CABuilt 1998 · S/N 172S8010 N400KXSpritzair LLC · Durham, NCBuilt 2003 · S/N T18208212 N400USUnited States Aviation Underwriters Inc · Millington, TNBuilt 2004 · S/N T18208276 N401AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2020 · S/N 172S12509 N401EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2020 · S/N 172S12535 N401LPMustang Sally Aviation LLC · Camden, SCBuilt 2003 · S/N 172S9401 N401SWAnderson James Kenneth Jr · Tulsa, OKBuilt 2011 · S/N 18282301 N4022WAero Equities LLC · Ventura, CABuilt 2006 · S/N 172S10131 N402CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13235 N402CVCivil Air Patrol · Maxell Afb, ALBuilt 2016 · S/N 18282442 N402DJFlying Mermaid LLC · Aiea, HIS/N 172S9290 N402ERLeighnor Aircraft LLC · Prescott, AZBuilt 1997 · S/N 17280242 N402PEDiegos Pet Rescue LLC · Orlando, FLBuilt 1998 · S/N 17280594 N403CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13237 N403CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282448 N403EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12639 N403FRBas Part Sales LLC · Greeley, COS/N 17280245 N403GFSky Mates Inc · Wilmington, DEBuilt 2005 · S/N 172S9918 N403SPHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1999 · S/N 172S8295 N404DCN404dc LLC · Kennesaw, GABuilt 2023 · S/N 172S13065 N404EPSkywest Leasing Inc · St George, UTBuilt 2014 · S/N 172S11436 N404FREdb Air Inc · Wilsonville, ORBuilt 1997 · S/N 17280282 N404KRCenterline Aviation Inc · Middletown, DEBuilt 2009 · S/N 18282203 N4053FBluebird & Blue Skys LLC · St Simons Is, GABuilt 2023 · S/N 18283210 N405CCLussier Michael N · Sutton, MABuilt 2006 · S/N T18208602 N405CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282439 N405EFEagle Flying Club Of Embry Riddle Aeronautical · Daytona Beach, FLBuilt 2012 · S/N 172S11154 N405ESIasco Flight Training Inc · Redding, CABuilt 1997 · S/N 17280219 N405FAWestosha Flying Club Inc · Kenosha, WIBuilt 2003 · S/N 172S9405 N405SPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1999 · S/N 172S8298 N405TBPiland Donald A · Gulf Shores, ALBuilt 2006 · S/N T18208608 N405TTGramling Terry Dewayne Jr · Corinth, MSBuilt 2007 · S/N T18208768 N406CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282440 N406EPChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11437 N406FRLunken Flight Training Center LLC · Cincinnati, OHS/N 17280297 N406JASpartan Education LLC · Tulsa, OKBuilt 2007 · S/N 172S10628 N406LBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2005 · S/N T18208406 N406TAAircraft Unlimited Inc · Pierre, SDBuilt 2003 · S/N 172S9406 N406VCVercruyssen Max · Honolulu, HIS/N T18208092 N407BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280937 N407CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282444 N407EBAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11438 N407FRRich Carolyn A · Redondo Beach, CABuilt 1997 · S/N 17280234 N407MD9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12764 N407SCAlpha Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12588 N408CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282446 N408EPAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11439

Back to AD 2005-05-53 R1