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.

N915DDWest Michigan Aviation Academy · Grand Rapids, MIBuilt 1999 · S/N 172S8149 N915JTLd Aviation LLC · Durango, COFirst renewal noticeBuilt 2005 · S/N T18208444 N915LSBlack Bear Aviation LLC · Camden, DEBuilt 2023 · S/N 18283235 N915TAAurora Aircraft LLC · Waterford, MIBuilt 2006 · S/N 172S10358 N9161TMenagerie Enterprises Inc DBA · Denison, TXBuilt 2011 · S/N 172S11093 N916BAMaya Aircraft Holdings LLC · Lee, NHBuilt 2002 · S/N 172S9116 N916BQ9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12756 N916ET9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12759 N916FT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12758 N916GW9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12760 N916HT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12761 N916KTPelican Flight Training LLC · San Carlos, CABuilt 2021 · S/N 172S12763 N916MABusch Brett · Stanford, MTBuilt 1999 · S/N 172S8265 N916MCJanicke Kenneth O · Wichita, KSBuilt 2009 · S/N T18208914 N916NT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12762 N916PBM & G Aircraft Management LLC · Aurora, ORBuilt 2021 · S/N 172S12765 N916QTElizabeth City State University · Elizabeth City, NCBuilt 2021 · S/N 172S12766 N916RR9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12767 N916TAAtp Aircraft 4 LLC · Wilmington, DES/N 17281076 N916UT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12768 N916WRPsl Surveys · Manassas, VAFirst renewal noticeS/N 18282262 N9171UAir Alpine Activities Inc Trustee · Wilmington, DES/N T18209032 N917CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8337 N917MAKs Flying Club Inc · Manhattan, KSBuilt 1999 · S/N 172S8270 N9181PNorthwestern Michigan College · Traverse City, MIBuilt 2011 · S/N 172S11084 N918CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8338 N918MYFlying Pigs LLC · Tulsa, OKBuilt 2005 · S/N 18281512 N918TPAzure Quest LLC · Cleveland, TNBuilt 2007 · S/N 18281904 N918WMStone City Charters LLC · Anamosa, IABuilt 2008 · S/N 18282068 N91920Brodel Adam · Grass Valley, CABuilt 2007 · S/N 18281921 N91934N91934 LLC · Evergreen, COBuilt 2012 · S/N 17281613 N91936Oklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281614 N91966Wings Over Texas Holdings LLC · Denton, TXS/N 17281616 N9196WOklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281615 N9198WOklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281617 N91996Oklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281619 N9199ZOklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281618 N919CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8339 N919EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2019 · S/N 172S12378 N919MKRyan Jacqueline Lee · Bend, ORS/N T18208019 N919TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 2000 · S/N 17280843 N919TCD & S Aviation LLC · Spring, TXBuilt 2005 · S/N 172S10019 N919ZATextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2025 · S/N 172S13350 N91CYVan Bortel Aircraft Inc · Arlington, TXBuilt 2023 · S/N T18209102 N91FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12951 N91FRJanie Air Inc · Roseville, CABuilt 2008 · S/N T18208859 N91FSEastern Kentucky University · Richmond, KYBuilt 1997 · S/N 17280302 N91PFSkyline Solutions Inc · Deland, FLBuilt 2006 · S/N 172S10302 N92004Oklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281621 N9200BChristiansen Aviation LLC · Wilmington, DEBuilt 2012 · S/N 17281620

Back to AD 2005-05-53 R1