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.

N907SEAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13479 N907WKNational Aircraft Leasing Corp · Manassas, VAS/N 18282197 N9085QKep2 Aviation LLC · Belmar, NJBuilt 2011 · S/N T18209023 N9086ZCy Air LLC · Springfield, MOBuilt 2011 · S/N 18282281 N908CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8331 N908EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12970 N908FGRidgeline Assets LLC · Wilmington, DEBuilt 2021 · S/N 172S12724 N908MCL2 Leasing LLC · Orem, UTS/N 18281900 N9095RCavalrei Inc · Fresno, CABuilt 2011 · S/N T18209025 N9096ZChristianen Aviation LLC · Wilmington, DEBuilt 2011 · S/N 172S11086 N909CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8909 N909CQVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 18281618 N909CSBarbers Point Flight School LLC · Kapolei, HIBuilt 2021 · S/N 172S12609 N909DBN909db Aviation Services LLC · Colorado Springs, COBuilt 1997 · S/N 17280031 N909DWDamon Matt · Holladay, UTS/N T18208080 N909EDEdwards Aero Club · Edwards Afb, CABuilt 2012 · S/N 172S11155 N909EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12973 N909KSKingsky Flight Academy LLC · Lakeland, FLBuilt 2005 · S/N 172S10031 N90FLTegridy Equipment Leasing LLC · Aurora, ORBuilt 1998 · S/N 17280562 N90HPOklahoma Department Of Public Safety · Norman, OKBuilt 2007 · S/N 18282017 N90LUTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13586 N90SUOhio State University · Columbus, OHBuilt 2000 · S/N 172S8475 N9101RMiddle Village Enterprises LLC · Maspeth, NYBuilt 2011 · S/N 172S11090 N9103ZMountain Pro Imaging Pllc · Omak, WABuilt 2011 · S/N T18209036 N910AAWest Michigan Aviation Academy · Grand Rapids, MIBuilt 1999 · S/N 172S8173 N910CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8332 N910HPState Of Ohio · Columbus, OHBuilt 2001 · S/N 18281012 N910LFNby Productions · Bristow, VABuilt 2011 · S/N 18282284 N910SEBates Jonathan R · Chatsworth, CABuilt 2004 · S/N 172S9604 N91126Valiair Lc Trustee · Casper, WYBuilt 2006 · S/N T18208489 N91160Brown Jeffrey C · Saint Augustine, FLBuilt 2011 · S/N 18282297 N911LAMindy Limited LLC · Muscatine, IABuilt 1998 · S/N 17280639 N912AZN912az LLC · Miami, FLBuilt 2003 · S/N 172S9475 N912EXObr Leasing · Bristow, VABuilt 2010 · S/N 18282231 N912JRN912jr LLC · Dover, DEBuilt 1999 · S/N 172S8200 N912LBArizona Flyers Club Inc · Tucson, AZBuilt 2000 · S/N 172S8609 N912VMAbove Standard Aviation Inc · South Lake Tahoe, CABuilt 2004 · S/N T18208293 N913CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8333 N913MAKennedy Michael J · Gilbert, AZBuilt 1999 · S/N 17280777 N914JPNelen Richard Jj · Fort Collins, COBuilt 2008 · S/N T18208893 N914RLNichols Charles C · Hanford, CABuilt 2004 · S/N 18281399 N914SCHotel Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13438 N914SWSilver Express Co DBA · Miami, FLBuilt 1999 · S/N 172S8160 N914TALankenau John · Lake Havasu City, AZBuilt 2024 · S/N T18209114 N9154YNolan Daniel R · Wilmington, NCBuilt 2001 · S/N 18280971 N9157A9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12755 N915AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13546 N915CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8335 N915CRVan Bortel Aircraft Inc · Arlington, TXBuilt 2006 · S/N T18208519 N915DAb Prop Plane II LLC · Metairie, LABuilt 2017 · S/N 172S12071

Back to AD 2005-05-53 R1