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.

N6078TSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2006 · S/N T18208621 N607DMAdx LLC · Saint Marys, KSBuilt 2002 · S/N T18208138 N607MLIprop LLC · Palm Beach Gardens, FLBuilt 2006 · S/N 18281849 N607TMN607tm LLC · Englewood, COBuilt 2023 · S/N T18209125 N60809Van Bortel Aircraft Inc · Arlington, TXBuilt 2008 · S/N 18282063 N608EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12707 N608GLWetzel Gary Charles · Dallas, TXBuilt 2008 · S/N T18208901 N608SHNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282198 N6097GSargester Aviation LLC · Middletown, DEBuilt 2004 · S/N 172S9673 N60986Kinn Folk LLC · Anchorage, AKBuilt 2008 · S/N T18208826 N609FJMustang Sally Aviation LLC · Camden, SCBuilt 2019 · S/N 172S12398 N60SVTextron Aviation Inc · Wichita, KSS/N 172S13629 N610DBPvr Construction LLC · Wilmington, DEBuilt 2006 · S/N T18208504 N610EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12711 N610SPPocket Rocket LLC · San Francisco, CABuilt 2000 · S/N 172S8591 N6110KJarrett Air LLC · Avon Park, FLBuilt 2006 · S/N T18208612 N611ADValiair Lc Trustee · Casper, WYBuilt 2003 · S/N T18208196 N611DNNelson Donald · Lavalette, WVBuilt 2025 · S/N T18209182 N611EKWings Over Texas Holdings LLC · Denton, TXBuilt 2006 · S/N 172S10282 N611HPFlorida Highway Patrol · Tampa, FLFirst renewal noticeBuilt 2006 · S/N 18281873 N611PTSierra Automation Inc · Weiser, IDBuilt 2008 · S/N T18208902 N611SFWood Automotive Inc · Cropwell, ALBuilt 2023 · S/N 18283224 N61237Phoenix East Aviation LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10674 N6125PThomas Roger · Hudson, OHBuilt 2004 · S/N 18281387 N612DPCarlson Glenn Alan · Byron Center, MIBuilt 2007 · S/N 18281953 N612JATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13588 N612PDMenagerie Enterprises Inc DBA · Denison, TXBuilt 2015 · S/N 172S11647 N612XMexico Medical Missions · Missouri City, TXBuilt 2003 · S/N T18208202 N6137QJeffery & Weiss Holdings LLC · Long Beach, CABuilt 2008 · S/N 172S10682 N61398Ali Rizwan Rajab · Richmond, TXBuilt 2008 · S/N 18282066 N613ADhs Operations LLC · Wilmington, DEBuilt 1997 · S/N 17280248 N613ERTextron Aviation Inc · Wichita, KSS/N 172S13655 N613ESRed Devil Aviation LLC · Aberdeen, SDBuilt 2005 · S/N T18208424 N613LGRidgeline Assets LLC · Wilmington, DEBuilt 2002 · S/N 172S9252 N613PFGeorgia Forestry Commission · Macon, GAS/N 18281139 N613SPAirmart Inc · Lexington, KYBuilt 2000 · S/N 172S8597 N61422Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13087 N61455Hutcheson David Carl · Santa Rosa Beach, FLBuilt 2004 · S/N 18281363 N6145H1100 Flournoy LLC · Alice, TXBuilt 2008 · S/N T18208827 N6146AMartinez Richard Ben · Sammamish, WABuilt 2008 · S/N T18208828 N61474Harper Analeasa Leighan · Clarksville, TNBuilt 2004 · S/N 18281370 N614EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12712 N614FAHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2004 · S/N 172S9614 N614KSDiy Travel LLC · Seattle, WABuilt 2012 · S/N T18209088 N614LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2019 · S/N 172S12257 N6152HMarcair Inc · Fort Worth, TXBuilt 2008 · S/N 172S10691 N615EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12716 N615SPChesapeake Skyhawks Inc · Wilmington, DEBuilt 2000 · S/N 172S8603 N615TWClark Jim W · Claremore, OKBuilt 2020 · S/N 18283110 N6160DAugusta Capital LLC · Hellertown, PABuilt 2008 · S/N T18208832

Back to AD 2005-05-53 R1