Registered aircraft · 6,034

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.

N146TCN146tc LLC · Minneapolis, MNBuilt 2002 · S/N 172S9146 N1472PFlight School Of Texas LLC · Wilmington, DEBuilt 2005 · S/N 172S9899 N147AJAviation Solutions LLC · Louisville, KYBuilt 2006 · S/N T18208482 N147CETwin P Aviation LLC · Fort Worth, TXBuilt 2013 · S/N T18209098 N147HAPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10219 N147HBCooley Timothy · Gilbert, AZBuilt 2017 · S/N 18283011 N14814Florida Flight Training Center Inc · Venice, FLBuilt 2007 · S/N 172S10451 N14829Ssea Properties LLC · Double Oak, TXBuilt 2007 · S/N 172S10585 N1483CWang Helin · Dana Point, CABuilt 2005 · S/N T18208419 N1483L83l Ventures LLC · San Carlos, CABuilt 2007 · S/N 18281960 N1484BMann Aviation Inc · Long Beach, CABuilt 2007 · S/N 172S10452 N1485CLiebowitz Alan · Sioux Falls, SDBuilt 2005 · S/N T18208421 N1488CChristiansen Aviation LLC · Wilmington, DEBuilt 2022 · S/N 172S12896 N1489LBusiness Mens Flying Club Inc · Naperville, ILBuilt 2007 · S/N 18281901 N148GHLattimore Partners LLC · Fort Worth, TXBuilt 2005 · S/N T18208417 N1492UD & S Aviation LLC · Spring, TXBuilt 2007 · S/N 18281962 N1493RChaffin Alex · Fayetteville, ARBuilt 2005 · S/N 18281694 N1496CSbma Services LLC · Mcclellan, CABuilt 2005 · S/N 18281693 N149ABVarga Miklos · Helendale, CABuilt 2005 · S/N T18208372 N149CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282190 N149FCDepartment Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2017 · S/N 18283002 N149GRJoemchem LLC · Sparta, TNBuilt 2007 · S/N T18208698 N149LAColumbia Leasing LLC · Hillsboro, ORBuilt 2024 · S/N 172S13125 N149UDW Air LLC · Chicago, ILBuilt 2003 · S/N 17281185 N14PVRogers Michael P · Neenah, WIBuilt 2003 · S/N 172S9528 N14QWDinucci Mario · Auburn, CABuilt 2006 · S/N 18281760 N14WGWest Coast Equipment Leasing LLC · Aurora, ORBuilt 2019 · S/N 172S12415 N1502EElizbeth City State University · Elizabeth City, NCBuilt 2005 · S/N 172S9900 N1507XGolf November Aero LLC · Sunnyvale, CABuilt 2005 · S/N 172S9903 N150CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283268 N150SUOhio State University · Columbus, OHBuilt 2015 · S/N 172S11565 N150TESummit Air LLC · San Diego, CABuilt 2009 · S/N 172S10996 N150TH150th Aero Flying Club · Morristown, NJBuilt 2003 · S/N 172S9453 N151FCDepartment Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2006 · S/N 18281874 N151PAIntermountain Fabrication LLC · Jerome, IDBuilt 2003 · S/N T18208186 N15222Southeast Aircraft Leasing LLC · Jacksonville, FLBuilt 2007 · S/N 172S10454 N1522RN1522r LLC · Mequon, WIBuilt 2008 · S/N 172S10716 N15242Bluclouds LLC · Kirkland, WABuilt 2005 · S/N 18281614 N15255Elizabeth City State University · Elizabeth City, NCBuilt 2007 · S/N 172S10455 N152CFCharlie Fox LLC · Wilmington, DEBuilt 2002 · S/N 18281074 N152CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282335 N152SAXd Aviation LLC · Castle Rock, COBuilt 2013 · S/N 172S11275 N153CSSawyer Jonathan · Littleton, COS/N T18209043 N153FCDepartment Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2006 · S/N 18281774 N153PCRegistered aircraftBuilt 2009 · S/N 172S10956 N153TAAmerican Eagle 1 LLC · Kimberling City, MOBuilt 2001 · S/N 18281053 N1543TVan Bortel Aircraft Inc · Arlington, TXBuilt 2007 · S/N T18208781 N1544CElite Approach LLC · Chesterfield, MOBuilt 2000 · S/N 172S8365 N154CPCivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283319 N154FCDepartment Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2006 · S/N 18281785

Back to AD 2005-05-53 R1