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.

N5239YDumitrache Christina Marie · Mankato, MNBuilt 2009 · S/N 18282169 N523ABVector Air LLC · Erie, COBuilt 1999 · S/N 172S8307 N523ERBagamaspad Alan M · Reseda, CABuilt 2001 · S/N 172S8925 N523NDSunrise Aviation Inc · Ormond Beach, FLBuilt 2010 · S/N 172S11062 N5241SHpt Aero LLC · Longboat Key, FLBuilt 2009 · S/N T18208954 N5242NDonnelly Donald Dean Trustee · Tyler, TXS/N T18208956 N5242URegistered aircraftBuilt 2009 · S/N T18208957 N5243TBayley Inc · Henderson, NVBuilt 2009 · S/N T18208963 N5244QVan Bortel Aircraft Inc · Arlington, TXBuilt 2009 · S/N T18208964 N524CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 18283031 N524NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10979 N52519Northwestern Michigan College · Traverse City, MIBuilt 2009 · S/N 172S10903 N5251ZMustang Sally Aviation LLC · Camden, SCBuilt 2009 · S/N 172S10902 N52522Mustang Sally Aviation LLC · Camden, SCBuilt 2009 · S/N 172S10905 N5252JNorthwestern Michigan College · Traverse City, MIBuilt 2009 · S/N 172S10904 N52531Csa Aircraft Leasing LLC · Salt Lake City, UTBuilt 2002 · S/N 172S9172 N52535Voroshuck Clayton T · Sunnyvale, CABuilt 2002 · S/N 172S9173 N5253CMustang Sally Aviation LLC · Camden, SCBuilt 2009 · S/N 172S10906 N5253XMaranatha Insurance Service Inc · Rancho Cucamonga, CABuilt 2002 · S/N 172S9169 N5254ABuffy Aero LLC · Suwanee, GABuilt 2002 · S/N 18281157 N5254QRocky Mountain Flight Consultants LLC · Boulder, COBuilt 2002 · S/N 172S9206 N5254WGlacier Peak Aviation LLC · Carnation, WABuilt 2002 · S/N 172S9207 N5255RZin Services LLC · Dover, DEBuilt 2009 · S/N 172S10987 N5256SFargo Jet Center LLC · Fargo, NDBuilt 2009 · S/N 172S10901 N5257ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2009 · S/N 18282181 N5258YChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9141 N525MJCohen Heath P · Lake Havasu City, AZBuilt 2006 · S/N T18208533 N525NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10817 N52606Cirrus Aviation Inc · Sarasota, FLBuilt 2009 · S/N 172S10995 N5262QReinhart Gregory D · Waunakee, WIBuilt 2009 · S/N T18208975 N5262UL&W Aircraft Investment LLC · Homestead, FLBuilt 2002 · S/N 172S9175 N5262YLead Turn Aviation LLC · Ogden, UTBuilt 2002 · S/N 172S9176 N5264RHenslee Aviation LLC · Hobbs, NMBuilt 2009 · S/N T18208982 N52657Honeycutt Holdings Inc · Charlotte, NCS/N T18208172 N52678Land And Sea Aviation Alaska LLC · Anchorage, AKBuilt 2026 · S/N 172S13556 N5267RCastlegate Corp · Monee, ILFirst renewal noticeBuilt 2002 · S/N 172S9180 N5267YCkb Management LLC · Fayetteville, ARBuilt 2002 · S/N 172S9181 N52694Sullivan Michael E Trustee · Granite Bay, CABuilt 2002 · S/N 18281161 N5269NHigh Maintenance Inc · San Luis Obispo, CABuilt 2002 · S/N 172S9184 N526EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13524 N526ERLong Island Aviators LLC · Seaford, NYBuilt 2002 · S/N 172S9110 N526LKKenzy 2022 LLC · Castle Rock, COBuilt 2022 · S/N 172S12923 N526MEMike Whiskey Echo LLC · Camden, DEBuilt 2025 · S/N T18209168 N526NDSpartan Education LLC · Tulsa, OKBuilt 2010 · S/N 172S11063 N5270GLewis University · Romeoville, ILBuilt 2009 · S/N 172S11003 N52712Macmillan Elizabeth A · Franklin, MABuilt 2002 · S/N 172S9192 N52715Echo Sierra 54 LLC · Hagerstown, MDBuilt 2002 · S/N T18208174 N5271FUnverfehrt David C · Ocala, FLBuilt 2009 · S/N T18208983 N5272NMaddie LLC · Hinton, WVBuilt 2009 · S/N 172S10999 N52731Bravo Leasing LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10974

Back to AD 2005-05-53 R1