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.

N53587Chapel Hill Flying Club Inc DBA · Sanford, NCBuilt 2003 · S/N 172S9407 N5359KAbove And Beyond Aviation LLC · Austin, TXBuilt 2003 · S/N 172S9447 N535CHThibault Dominic · Titusville, FLS/N T18209212 N535EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2024 · S/N 172S13168 N535HFPars Avn Corp · Wilmington, DEBuilt 2000 · S/N 17280926 N535KSKent State University · Stow, OHBuilt 2013 · S/N 172S11321 N535VWAtp Aircraft 4 LLC · Wilmington, DEBuilt 2000 · S/N 172S8384 N53610Joe Wigginton Leasing LLC · Henderson, NVS/N 18281223 N53614Orange County Flight Center Inc · Santa Ana, CABuilt 2003 · S/N 172S9413 N53636Sterling Flight Training · Jacksonville, FLS/N 172S9415 N5363QCary Gosney Crna Inc · Sonora, CABuilt 2003 · S/N T18208203 N5363ZClover Park Technical College · Lakewood, WABuilt 2003 · S/N 17281173 N5364ABradley Flying Association · Peoria, ILFirst renewal noticeBuilt 2003 · S/N 172S9417 N536DDHughes Jacob · Denver, COBuilt 2004 · S/N T18208317 N536EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2024 · S/N 172S13171 N536GRNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282182 N536HFVan Anda Aviation LLC · Apopka, FLBuilt 2000 · S/N 17280954 N536KSKent State University · Stow, OHBuilt 2025 · S/N 172S13365 N536LAhmed Ejaz DBA · Carrollton, GABuilt 2017 · S/N 18283023 N536NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10932 N536SPEastern Cincinnati Aviation · Batavia, OHBuilt 2000 · S/N 172S8388 N536THLanier Equipment Leasing LLC · Gainesville, GABuilt 2021 · S/N 172S12636 N537AMMazel Wings LLC · Camden, DEBuilt 2025 · S/N T18209176 N537EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2025 · S/N 172S13305 N537HFSilver Express Co · Miami, FLBuilt 2000 · S/N 17280891 N537KSKent State University · Stow, OHBuilt 2014 · S/N 172S11388 N537NDSpartan Education LLC · Tulsa, OKBuilt 2009 · S/N 172S10990 N537SAMills Michael R · Saratoga Springs, NYBuilt 2021 · S/N 18283133 N537SP5280 Flying Club LLC · Castle Pines, COBuilt 2000 · S/N 172S8393 N538CPCivil Air Patrol · Maxwell Afb, ALBuilt 2011 · S/N T18209030 N538EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13078 N538HFSun Aircraft Management LLC · Ormond Beach, FLBuilt 2000 · S/N 17280873 N538KSKent State University · Stow, OHBuilt 2014 · S/N 172S11389 N538NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10832 N538SPRc Flying Partners LLC · Fair Oaks, CABuilt 2000 · S/N 172S8395 N539CPCivil Air Patrol · Maxwell Afb, ALBuilt 2011 · S/N T18209031 N539KSKent State University · Stow, OHBuilt 2015 · S/N 172S11646 N539MYMiller Aviation LLC · Murfreesboro, TNBuilt 2010 · S/N 18282238 N539NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10850 N53AAMustang Sally Aviation LLC · Camden, SCBuilt 2016 · S/N 172S11737 N53FFWingsleasing LLC · Wichita, KSBuilt 2022 · S/N 172S12876 N53FVTorres Ramon Luis · San Juan, PRS/N 18281083 N53KPMateos Louise M · Santa Clara, CABuilt 2005 · S/N 18281541 N53LULetourneau University · Longview, TXBuilt 2024 · S/N 172S13200 N540CFCertified Aviation LLC · Morristown, NJBuilt 2005 · S/N 172S9898 N540EREmbry-Riddle Aeronautical University Inc · Prescott, AZS/N 172S13308 N540KSKent State University · Stow, OHBuilt 2016 · S/N 172S11672 N540NDAerosim Academy Inc · Sanford, FLBuilt 2010 · S/N 172S10984 N541ESouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281593 N541EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2025 · S/N 172S13311

Back to AD 2005-05-53 R1