Skip to content

AD 2005-05-53 R1

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.

N655EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12453 N655NDInternational Air Services Inc Trustee · Carson City, NVBuilt 2014 · S/N 172S11471 N655PDJls Aviation LLC · Sarasota, FLBuilt 2000 · S/N 172S8655 N65602Ballew James H · Las Vegas, NVBuilt 2004 · S/N 18281487 N65637N65637 LLC · Manassas, VAS/N 172S9739 N65638Mid Continent Aircraft Corp · Hayti, MOBuilt 2004 · S/N 18281467 N65641Lexington Flying Club Inc · Lexington, KYBuilt 2005 · S/N 17281233 N65647Jmc Aviation LLC · Santa Rosa, CABuilt 2005 · S/N 172S9778 N65664Southwest Flying Club Inc · The Woodlands, TXBuilt 2004 · S/N 18281489 N65672Jensen Thomas · Nixa, MOS/N 18281474 N656CBUniversity Of Central Missouri · Warrensburg, MOBuilt 2022 · S/N 172S12800 N656CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281656 N656EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12454 N656FCFlorida Department Of Agriculture & Consumer Svcs · Tallahassee, FLBuilt 2017 · S/N 18283008 N656MAWings Over Texas Holdings LLC · Denton, TXS/N 17280924 N656SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 172S8061 N65729Nevrdul LLC · Cambridge, MDBuilt 2005 · S/N 172S9791 N65738Mc Collom Perry C · Saint Louis, MOBuilt 2004 · S/N 172S9746 N65745Mustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9748 N65790Horan Peter · North Easton, MABuilt 2005 · S/N 172S9787 N65795Bank Of Utah Trustee · Salt Lake City, UTS/N 172S9977 N657CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281657 N657EREmbry-Riddle Aeronautical University · Prescott, AZBuilt 2020 · S/N 172S12455 N657SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 172S8062 N657TPZma LLC · North Little Rock, ARBuilt 2010 · S/N 18282253 N65805Wilkerson William E · Crewe, VABuilt 2004 · S/N T18208346 N65841Just Plane Stuff Inc · Jackson, MSBuilt 2004 · S/N 172S9763 N65853Morando Donald W · Myrtle Beach, SCBuilt 2004 · S/N 18281490 N65860Edb Air Inc · Wilsonville, ORBuilt 2004 · S/N 18281491 N65862Top Flight Aviation Inc · Corona, CABuilt 2004 · S/N 18281493 N658AKWright David · Bellaire, TXBuilt 2010 · S/N T18209007 N658CPArizona Air Salvage · Phoenix, AZBuilt 2005 · S/N 18281658 N658EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12539 N658MACantele Joseph D · Hickory Hills, ILBuilt 2000 · S/N 172S8529 N658PWWheels Up Aviation LLC · Cochran, GABuilt 2008 · S/N 18282098 N658XLMertz George H III · Reading, PABuilt 1997 · S/N 17280096 N65903N65903 LLC · Union Gap, WABuilt 2004 · S/N 18281501 N65904Electra Aviation LLC · Wilmington, DEBuilt 2004 · S/N 18281502 N65908Sanders Thomas W · Overgaard, AZBuilt 2004 · S/N T18208347 N65912Lima Alfa LLC · Whitefish, MTBuilt 2004 · S/N T18208348 N65920Hellroaring Technologies Inc · Polson, MTBuilt 2004 · S/N T18208350 N65926Pc Aviation LLC · Kanarraville, UTBuilt 2004 · S/N T18208353 N65927Garmin International Inc · Olathe, KSBuilt 2004 · S/N T18208354 N65932Techflitewest LLC · Brookville, OHBuilt 2004 · S/N T18208356 N65937Berendschot Leonardus · Huntsville, TXBuilt 2004 · S/N 18281492 N65956Ameriflyers Of Texas Inc · Addison, TXS/N 172S9829 N65957Skybourne LLC · Stuart, VABuilt 2004 · S/N 18281484 N65971Georgalos Aircraft LLC · Eagle Point, ORBuilt 2004 · S/N T18208340 N65988Arkansas Industrial Manufacturing LLC · Wilmington, DEBuilt 2005 · S/N 18281513 N65991Crysler Douglas Michael · Rockford, MIBuilt 2005 · S/N 18281514

Back to AD 2005-05-53 R1