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.

N65995Phoenix Flyers Inc · Mesa, AZBuilt 2005 · S/N 18281515 N659EREmbry-Riddle Aeronautical University Inc · Prescott, AZS/N 172S12541 N659SPChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8064 N65BLWhite Craig S · Troy, OHBuilt 2001 · S/N 18281069 N65EHTextron Aviation Inc · Wichita, KSS/N T18209213 N65FDBarnstormer Leasing LLC · Murfreesboro, TNBuilt 2017 · S/N 18283010 N65HFHorizon Flight Center LLC · Chesapeake, VABuilt 2024 · S/N 172S13138 N65KCBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 18281015 N65TJHigh Wing 182t LLC · Helena, MTBuilt 2025 · S/N T18209169 N66005Slp III 1 LLC · Columbia, MOBuilt 2005 · S/N T18208359 N66010Crane William Jr · Somerville, ALBuilt 2005 · S/N 172S9771 N66025Suburban Air Corp · Castro Valley, CAS/N 172S9777 N66029Wpf Air LLC · Fort Myers, FLBuilt 2005 · S/N T18208365 N66046Palm Beach Flight Training Corp · Lantana, FLBuilt 2005 · S/N 172S9786 N66068Phoenix East Aviation LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9790 N66070Obetz Robert S · Manheim, PABuilt 2005 · S/N 18281522 N66083Bravo Zulu Aviation LLC · Torrance, CABuilt 2005 · S/N 172S9938 N66085Bellers Aviation Inc · Fremont, CABuilt 2004 · S/N 172S9768 N660EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12543 N660JWLearning 2 Fly LLC · Cave Creek, AZBuilt 2005 · S/N 172S9788 N660SPRobert Devers Solutions · Hermosa Beach, CABuilt 1998 · S/N 172S8065 N660TJmta Management LLC · Clinton, MOBuilt 2023 · S/N 18283226 N66100Pj Aviation Holding LLC · Eden Prairie, MNBuilt 2004 · S/N T18208335 N66104Rhb Aviation LLC · New Orleans, LABuilt 2005 · S/N 172S9781 N66135Miller Robert · Pierpont, OHS/N 18281526 N66175Stohlquist James R · Alamosa, COBuilt 2005 · S/N T18208414 N66177Newman Ken · Hood River, ORBuilt 2005 · S/N T18208375 N661EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12544 N661PC661pc LLC · New Rockford, NDBuilt 2004 · S/N T18208312 N661TW12wam25 LLC · Helena, MTBuilt 2025 · S/N T18209191 N662CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 18283102 N662EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12548 N662SPCessna N662sp LLC · Duluth, GABuilt 1998 · S/N 172S8066 N662TMUpright Corp · Kentfield, CABuilt 2004 · S/N T18208247 N663CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12722 N663SPN663sp LLC · Stuart, FLS/N 172S8067 N664CAChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10135 N664CPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283357 N664EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12549 N665BCrosby Aviation LLC · Bend, ORBuilt 2001 · S/N T18208011 N665CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12532 N665CSPurdue Aviation LLC · West Lafayette, INBuilt 2016 · S/N 172S11665 N665RTN665rt LLC · Palm City, FLBuilt 1998 · S/N 17280507 N667BLClover Park Technical College · Lakewood, WABuilt 2026 · S/N 172S13555 N667CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 18283236 N667EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12556 N667SPHindi David · Cupertino, CABuilt 1998 · S/N 172S8070 N66888Registered aircraftAssigned (import), pending cancellationS/N 17281380 N668CSTom Wood Aviation · Fishers, INBuilt 2016 · S/N 172S11667 N668EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12558

Back to AD 2005-05-53 R1