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.

N320SCEcho Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13352 N320SPLundstrom Aviation LLC · Ankeny, IABuilt 2003 · S/N 172S9490 N321CTFox Leasing Group LLC · Hollywood, FLBuilt 2000 · S/N 172S8390 N321EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2021 · S/N 172S12622 N321MECounty Of Henrico Virginia · Henrico, VABuilt 2000 · S/N 172S8566 N321PWSquaw Valley Air Force LLC · Reno, NVS/N T18208171 N321WFWings Over Texas Holdings LLC · Denton, TXBuilt 2001 · S/N 17280987 N322CSGlembot Troy M Trustee · Winchester, VABuilt 2012 · S/N 18282341 N322EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12782 N322JWBravo Aircfraft LLC · Alpharetta, GABuilt 2026 · S/N 172S13521 N322MMRiver Transport LLC · Redlands, CABuilt 2002 · S/N T18208126 N322TEEschmann Tim · Novinger, MOBuilt 2004 · S/N 18281372 N323JHThree Juliet Hotel LLC · Los Altos Hills, CABuilt 2012 · S/N T18209070 N323LPRkt Productions · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282244 N323YFYoo Investments Inc · Pharr, TXBuilt 2024 · S/N 18283253 N324CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12135 N324RPClear For Take Off LLC · Burlingame, CABuilt 2004 · S/N 18281422 N324SPHagele Aviation LLC · Hillsboro, ORBuilt 1999 · S/N 172S8249 N325MMBirdie Aviation LLC · Marble Hill, GABuilt 2007 · S/N 18281907 N325SPTfs Air LLC · Loveland, COBuilt 1999 · S/N 172S8251 N325SWSheroyair LLC · Sarasota, FLBuilt 2020 · S/N 18283097 N3265AMustang Sally Aviation LLC · Camden, SCBuilt 2005 · S/N 172S9878 N326CFWestbank Fishing LLC · Kiln, MSBuilt 2001 · S/N 18281045 N326EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13515 N326LPVista Aviation Inc · Pacoima, CAFirst renewal noticeBuilt 2003 · S/N 172S9326 N326MCJ&D Petroleum · Tallahassee, FLS/N 18281326 N326MEAiry LLC · Seattle, WABuilt 2000 · S/N 172S8573 N326PSPsl Surveys · Greenville, DEBuilt 2012 · S/N 18282344 N326UWForemost Well Service LLC · Dickinson, NDBuilt 2025 · S/N T18209184 N327ADGundry Adam · Superior, WIBuilt 2024 · S/N T18209164 N327GHTextron Aviation Inc · Wichita, KSS/N 18283369 N327SPAmeriflyers Of Texas Inc · Addison, TXBuilt 1999 · S/N 172S8254 N327STBeach Cities Real Property Holdings LLC · Hermosa Beach, CABuilt 2005 · S/N T18208447 N3288Mewmew Investment II LLC · Palo Alto, CABuilt 2020 · S/N 172S12430 N328CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283309 N328FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13220 N328MEFlying Start Aero Services LLC · Reno, NVS/N 172S8575 N328TASuburban Air Corp · Castro Valley, CABuilt 2003 · S/N 172S9328 N328TMMathews Thomas J · New Castle, INBuilt 2024 · S/N T18209148 N329KBMagee Brad D · Durango, COBuilt 2007 · S/N T18208788 N329MECentral Iowa Aviation LLC · Ankeny, IABuilt 2000 · S/N 172S8461 N329WPPhillips J Weston · West Jefferson, NCBuilt 2025 · S/N 18283329 N32LPBartlett Paul H · Nebo, NCBuilt 2025 · S/N 18283331 N32LTLt Leasing LLC · Saint Petersburg, FLBuilt 2021 · S/N 18283154 N330JEWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280299 N330MEUnique Educational Experiences · Signal Hill, CABuilt 2000 · S/N 172S8462 N330PMPractical Education LLC · New York, NYBuilt 2008 · S/N 172S10809 N331CHCh Wings LLC · Arvada, COBuilt 2022 · S/N 172S12917 N331CPCivil Air Patrol · Montgomery, ALBuilt 2019 · S/N 172S12342 N331GWFieldcrest Air LLC · Latrobe, PABuilt 2021 · S/N 18283147

Back to AD 2005-05-53 R1