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.

N51163Christiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 172S10930 N5116BQuantum Aviation LLC · Manchester, MDBuilt 2002 · S/N 172S9161 N51198Registered aircraftBuilt 2002 · S/N 18280990 N511DWD.B. Wood LLC · Levering, MIBuilt 2015 · S/N 18282373 N511EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12863 N511NDSunrise Aviation Inc · Ormond Beach, FLBuilt 2008 · S/N 172S10762 N5122UChristiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 172S10911 N5126JGull Rock Aviation LLC · Punta Gorda, FLBuilt 2001 · S/N 172S8992 N512CTCoast Flight Training And Management Inc · San Diego, CABuilt 2005 · S/N 17281264 N512DPCanal Aviation LLC · Dover, DEBuilt 2005 · S/N T18208420 N512ERTextron Aviation Inc · Wichita, KSS/N 172S13620 N512NDCoast Flight Training And Management Inc · San Diego, CABuilt 2008 · S/N 172S10763 N512SPAvolant Aviation LLC · Mooresville, NCBuilt 2000 · S/N 172S8371 N5130FC & M Dreamflights LLC · Mount Pleasant, SCBuilt 2002 · S/N 172S9068 N51313Echo Tango 03 LLC · Anthem, AZBuilt 2001 · S/N 172S9000 N51325Baldwin Gordon Lee Jr · Altamonte Springs, FLBuilt 2009 · S/N 172S10934 N5132RChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 172S9001 N5133KAa-Aero Inc · Fairfield, NJBuilt 2001 · S/N 172S9002 N5134BSalinas Four LLC · Salinas, CABuilt 2001 · S/N T18208103 N5135PChristiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 172S10936 N5135UEchols Mill Aviation LLC · Elberton, GAS/N 172S9008 N51362Caputi J Gary · Mashpee, MABuilt 2001 · S/N 172S9010 N5136CMonadnock Aviation Inc · Keene, NHBuilt 2002 · S/N 172S9150 N5138710fss - Usafa Aero Club · Usafa, COBuilt 2001 · S/N 172S9013 N51388Flight Line Resources Inc · Chandler, AZBuilt 2001 · S/N 172S9014 N5138VAdvanced Charter & Instruction LLC · Costa Mesa, CABuilt 2001 · S/N 172S9012 N51390Mustang Sally Aviation LLC · Camden, SCS/N 172S10892 N5139UCoosa Valley Aviation Inc · Wilmington, DEBuilt 2001 · S/N 172S9016 N5139WConnelly James · Spearman, TXBuilt 2009 · S/N T18208926 N513CTCoast Flight Training And Management Inc · San Diego, CABuilt 2009 · S/N 172S10925 N513EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13047 N513KMFreedom N513km LLC · Pacific City, ORBuilt 2013 · S/N T18209097 N513LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2007 · S/N 172S10494 N513MCWilliams Val · Victor, IDBuilt 2006 · S/N 18281811 N513NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10764 N513SPPlane Old Inc · New York, NYBuilt 2000 · S/N 172S8373 N513VMMccabes Supply Inc · Watertown, NYBuilt 2004 · S/N T18208310 N513WFMeow Meow LLC · Seattle, WABuilt 2004 · S/N 172S9756 N51413Mcpike William C · Ludington, MIBuilt 2002 · S/N 172S9042 N5141JSasser Nancy Elizabeth · Petaluma, CABuilt 2001 · S/N 18281062 N5141YCommonwealth Of Virginia · Fort Monroe, VABuilt 2002 · S/N 18281077 N5143QMelnyk George · Sheridan, ORBuilt 2002 · S/N T18208108 N5147JN5147j LLC A Series Of Aero Lease LLC · San Antonio, TXBuilt 2001 · S/N 172S9021 N5148VAyres Aviation LLC · Santa Monica, CABuilt 2002 · S/N 172S9025 N5148YIe3 Enterprise LLC · Elk Grove, CABuilt 2009 · S/N T18208929 N51495Wallace State Community College · Hanceville, ALBuilt 2009 · S/N 172S10891 N514DGSilver Surfer Enterprises LLC · Hot Springs, ARBuilt 2007 · S/N T18208722 N514ERTextron Aviation Inc · Wichita, KSS/N 172S13658 N514FCState Of Alabama · Montgomery, ALBuilt 2024 · S/N 18283282 N514HPState Of Ohio / Department Of Public Safety · Columbus, OHBuilt 2005 · S/N 18281651

Back to AD 2005-05-53 R1