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.

N268TZHague Robert A · Rogers, ARBuilt 2020 · S/N 18283108 N268ZMewmew Investment II LLC · Palo Alto, CABuilt 2023 · S/N 172S12947 N269DDAircraft Solutions Group LLC · Englewood, COBuilt 2005 · S/N 172S9981 N269EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13509 N269FGMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10885 N269MEGeorge'S Aviation Services · Honolulu, HIBuilt 2000 · S/N 172S8531 N269SFlightco Inc · Swainsboro, GABuilt 2001 · S/N 18281061 N269SAAlthof Equipment Management LLC · Jupiter, FLBuilt 2011 · S/N 18282280 N269SHDan Julian LLC · Woodway, TXBuilt 2007 · S/N T18208729 N26AAMustang Sally Aviation LLC · Camden, SCBuilt 2016 · S/N 172S11693 N26BQAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13219 N26KMPerformance Aviation Solutions LLC · Meridian, IDBuilt 2001 · S/N T18208051 N26LPAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13252 N270CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13089 N270CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282352 N270DMMarbry Holdings LLC · Naples, FLBuilt 2020 · S/N 18283115 N270FASchoettelkotte Christopher B · Friendswood, TXBuilt 2003 · S/N 18281270 N270JARegistered aircraftBuilt 2000 · S/N 172S8619 N270UOhio University · Albany, OHBuilt 2003 · S/N 172S9520 N2711RBoeing Employees Flying Association Inc · Renton, WABuilt 2001 · S/N 172S8864 N271AFBurke Aircraft Service Co LLC · Portsmouth, OHBuilt 2003 · S/N 18281188 N271CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13090 N271DCForum Aviation LLC · Middletown, DEBuilt 2005 · S/N 18281579 N271SLVan Bortel Aircraft Inc · Arlington, TXBuilt 2024 · S/N 18283271 N2726XSuttman Robert · Dayton, OHBuilt 2007 · S/N 18281913 N272ARWinging It Inc · Stephenson, MIS/N T18208055 N272FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13454 N272HFHorizon Flight Center LLC · Chesapeake, VABuilt 2022 · S/N 172S12776 N272LPAa-Aero Inc · Fairfield, NJBuilt 2002 · S/N 172S9272 N272MMTownair LLC · Sandy, UTBuilt 2006 · S/N 172S10105 N272SBBailey Aviation LLC · Chesapeake, VABuilt 2001 · S/N 172S8908 N272SPBlue Ryan LLC · Billings, MTBuilt 1998 · S/N 172S8016 N27300Rankin Kevin J · Maryville, MOBuilt 1998 · S/N 17280551 N2731YGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281202 N273CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282354 N273TCStanford Doug · Oak Harbor, WABuilt 2013 · S/N T18209090 N2740K2740k LLC · Prospect, KYBuilt 2006 · S/N T18208514 N2744WWilhelm LLC · Denver, COFirst renewal noticeBuilt 2004 · S/N 172S9644 N2745MNfh Aviation LLC · Pikeville, KYBuilt 1999 · S/N 17280586 N2746CChen Mark · Plano, TXBuilt 1998 · S/N 17280587 N274BBLcb Leasing · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282270 N274DGBourne Michael Paul · Crystal Bay, NVBuilt 2004 · S/N T18208260 N274MMHanzawa George DBA · Wahiawa, HIBuilt 2003 · S/N 172S9320 N275AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2014 · S/N 172S11442 N275PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2007 · S/N 172S10515 N275TXQualitair LLC Trustee · MichelstadtBuilt 2015 · S/N 172S11635 N276GTChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9281 N276SALiberty University · Lynchburg, VABuilt 2013 · S/N 172S11276 N276TATextron Aviation Inc · Wichita, KSS/N 18283366 N2772Lewis University · Romeoville, ILBuilt 2005 · S/N 17281252

Back to AD 2005-05-53 R1