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.

N9560SMoore Justin W · Hollywood Park, TXBuilt 1998 · S/N 17280495 N9560WGeneral Aviation LLC · Henderson, NVBuilt 1998 · S/N 17280496 N9561VAbove And Beyond Aviation LLC · Austin, TXBuilt 1998 · S/N 17280497 N9562PAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 17280499 N9562QSilverhawk Aviation Academy Oregon LLC · Ontario, ORBuilt 1998 · S/N 17280501 N9563AChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280502 N956CFHighwind Aero LLC · Inyokern, CABuilt 2002 · S/N 18281075 N956CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282409 N956ESHr Cabinets LLC · Nederland, TXBuilt 2017 · S/N 18283013 N956RLOlsen Eric Wesley · Reno, NVBuilt 2012 · S/N T18209075 N956SPN3812q LLC · San Diego, CABuilt 1999 · S/N 172S8156 N9572WDr Equipment LLC · Ackerly, TXBuilt 1998 · S/N 17280544 N9577WIasco Flight Training Inc · Redding, CABuilt 1998 · S/N 17280527 N9577ZAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280528 N9579VPlaisted Aviation LLC · Elk River, MNBuilt 1998 · S/N 17280529 N957DDDon Davis Aviation Inc · Henderson, KYBuilt 2021 · S/N 172S12775 N957EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S13001 N957ESVolar I LLC · Edmond, OKBuilt 2008 · S/N 172S10675 N9581GN9581g Corp · Skokie, ILBuilt 1998 · S/N 17280530 N958EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S13004 N959CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281969 N959JATriple Eagle Aviation LLC · Cambridge, VTBuilt 2007 · S/N 172S10510 N959TCPipe Dream Dreaming LLC · Kalispell, MTBuilt 2012 · S/N T18209056 N959TTVan Bortel Aircraft Inc · Arlington, TXBuilt 2001 · S/N T18208087 N959UAUniversity Of Alaska Anchorage · Anchorage, AKBuilt 2007 · S/N 172S10526 N959YBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 2023 · S/N 172S12959 N95BPPeraton Services LLC · Bozeman, MTBuilt 2012 · S/N 172S11108 N960AUAuburn University · Auburn, ALBuilt 2017 · S/N 172S12098 N960CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281990 N960MSMt San Antonio Community College District · Walnut, CABuilt 2001 · S/N 172S8859 N960TAInnoutaero LLC · Stockton, CAS/N 172S8960 N961AUAuburn University · Auburn, ALBuilt 2018 · S/N 172S12154 N961LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12031 N961RWBerchick Inc · Corrales, NMBuilt 2004 · S/N T18208303 N962AUAuburn University · Auburn, ALBuilt 2019 · S/N 172S12292 N962CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281972 N962JBNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282149 N962LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12032 N962PBNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282159 N963ACYoung Paul J · Hudson, MABuilt 1999 · S/N 172S8259 N963AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12478 N963CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281973 N963EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S13007 N963JADeland Aviation LLC · Deland, FLBuilt 2007 · S/N 172S10521 N963LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12033 N963SPAero Aircraft 11 LLC · Jacksonville, FLBuilt 1999 · S/N 172S8166 N963TASvetfur Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9610 N964AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12479 N964CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282410 N964EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S13010

Back to AD 2005-05-53 R1