Skip to content

AD 2005-05-53 R1

Registered aircraft · 6,035

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.

N20830Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12580 N2083FDetroit Public Schools Community District · Detroit, MIS/N 17280671 N20884Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12581 N20887N20887 LLC · Augusta, GABuilt 2005 · S/N T18208452 N208CPChristiansen Aviation LLC · Wilmington, DEBuilt 2020 · S/N 172S12502 N20910Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12582 N20913Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12583 N20945Georgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281295 N20957Mustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9571 N2097GMountain Air Aviation LLC · Fruit Heights, UTBuilt 2004 · S/N 172S9662 N2097SLong Island Aviators LLC · Seaford, NYBuilt 2004 · S/N 18281308 N2097TPatriot Aviation Inc · Greenville, DEBuilt 2004 · S/N 172S9585 N2098AAtp Aircraft 1 LLC · Wilmington, DEBuilt 1999 · S/N 17280762 N2098CLynch Stephen J · Stamford, CTBuilt 2004 · S/N T18208228 N2099DRollins Dale G · Covington, LABuilt 2004 · S/N 17281204 N2099NMicheal Charles E · Arlington, TXBuilt 2004 · S/N 18281333 N209JSCrystal Coast Training LLC · Kinston, NCBuilt 2023 · S/N 172S13008 N209KFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12826 N20APF & M Holdings LLC · Goshen, ALS/N T18208160 N20BQAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13216 N20DBLsn Air LLC · Morrison, COBuilt 2004 · S/N T18208331 N20EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2020 · S/N 172S12513 N20KHN20kh LLC · Clewiston, FLBuilt 2021 · S/N 18283153 N20MVElizabeth City State University · Elizabeth City, NCBuilt 2018 · S/N 172S12143 N20SUOhio State University · Columbus, OHBuilt 2015 · S/N 172S11623 N21002Gr Aircraft LLC · Rancho Mirage, CABuilt 2007 · S/N T18208677 N2100SBietsch Aviation LLC · Dumfries, VABuilt 2004 · S/N 172S9589 N21019Svetfur Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9595 N2101GCarter James E · Thornville, OHBuilt 2004 · S/N T18208230 N2101VWell Hung Metal LLC · Sulphur, LABuilt 2007 · S/N T18208733 N21022Ameriflyers Of Texas Inc · Addison, TXBuilt 2004 · S/N 172S9660 N2102PZima Aviation LLC · Huntington Beach, CABuilt 2004 · S/N 172S9594 N2103TIasco Flight Training Inc · Redding, CABuilt 2004 · S/N 17281205 N2103UCramm Raymond Eduard · Palmdale, CABuilt 2005 · S/N 18281660 N2104HGrenier Chad · Moorpark, CABuilt 2007 · S/N 172S10432 N21056N21056 LLC · Wayne, PABuilt 2007 · S/N 172S10434 N2105XAb Prop Plane II LLC · Metairie, LABuilt 2020 · S/N 172S12585 N2107UFlight World Inc · San Juan, PRBuilt 2004 · S/N 172S9603 N2108LSoutheast Aircraft Leasing LLC · Jacksonville, FLBuilt 2004 · S/N 172S9605 N2108ZPinnacle Aviation Services Inc · Encinitas, CABuilt 2004 · S/N 17281207 N2109LCaban-Loperena Jumil · Moca, PRBuilt 2004 · S/N 172S9609 N210HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2002 · S/N 172S9040 N210SUOhio State University · Columbus, OHBuilt 2020 · S/N 172S12431 N21147Woolf Sarah Clark · Fresno, CABuilt 2004 · S/N T18208234 N2114QJet Air Inc · Iowa City, IABuilt 2004 · S/N 172S9616 N2114RPower Michael L · Bend, ORBuilt 2004 · S/N T18208226 N2114UBravo Zulu Aviation LLC · Torrance, CAS/N 172S9618 N2115KLiprie Randal C · Lake Charles, LABuilt 2004 · S/N 18281322 N21180L&W Leasing LLC · Murfreesboro, TNS/N 172S9624 N2118JLamb Chops Inc · Bakersfield, CABuilt 2004 · S/N T18208238

Back to AD 2005-05-53 R1