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.

N5273FPsc Leasing LLC · Nokesville, VABuilt 2009 · S/N 18282193 N5273KColumbia Fire & Safety LLC · Wilmington, DEBuilt 2002 · S/N 18281162 N5273UKatola LLC · Anaheim, CABuilt 2002 · S/N 172S9193 N5274VH & R Aviation LLC · West Linn, ORBuilt 2009 · S/N 172S11005 N52753Omark Aviation LLC · Naples, FLBuilt 2002 · S/N 18281164 N52757Brady Aviation Ltd Co · Friendswood, TXBuilt 2002 · S/N 18281165 N5275CRamaswamy Ashok · Clearwater Beach, FLBuilt 2009 · S/N T18208988 N5275S75s Leasing LLC · Greenwood Village, COBuilt 2002 · S/N 172S9203 N5275WMustang Sally Aviation LLC · Camden, SCS/N 172S10938 N5276PBellers Aviation Inc · Fremont, CABuilt 2009 · S/N 172S11010 N5276YPadlock Ranch Co · Ranchester, WYBuilt 2002 · S/N T18208176 N52794Hawk Flyer 794 LLC · San Bruno, CABuilt 2002 · S/N 172S9211 N527DSSkyhawk Leasing LLC · Greenfield, INBuilt 2004 · S/N 172S9588 N527NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10818 N5280DHdw Florida Helicopters Inc · Pompano Beach, FLBuilt 2002 · S/N 172S9212 N5280RSpringbrook Leasing LLC · Daytona Beach, FLBuilt 2002 · S/N 172S9216 N5284SFly America Inc · Stanford, CABuilt 2010 · S/N 172S11026 N52858Channel Islands Aviation Inc · Camarillo, CABuilt 2002 · S/N 172S9186 N5286CUnited Flying Club Inc · Belmont, CABuilt 2002 · S/N 172S9219 N5288TG & S Air Adventures LLC · Jersey City, NJBuilt 2002 · S/N 172S9222 N5289HClarke Simon P · Seattle, WABuilt 2009 · S/N T18208936 N528CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 18283032 N528ERMary Air LLC · White Rock, NMBuilt 2001 · S/N 172S8926 N528KCBukhart Don · Blakely Island, WABuilt 2002 · S/N 18281109 N528LDCar Two Charlie LLC · Lewes, DEBuilt 2021 · S/N 18283130 N528LEZeus Aviation LLC · Carlisle, OHBuilt 2008 · S/N 18282046 N528LSYoung Robert A · Mount Desert, MEBuilt 2007 · S/N T18208798 N528MJAircraft Owners & Pilots Association · Frederick, MDBuilt 2001 · S/N 18280991 N528NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10825 N528PVMelin Mark Alan · Newport, NCBuilt 2007 · S/N 18282035 N528SCMaxxum Financial Group Inc · Destrehan, LABuilt 2002 · S/N 172S9210 N528SVFox Leasing Group LLC · Hollywood, FLBuilt 2004 · S/N 172S9754 N5290ESpacely Space Sprockets LLC · Aurora, ORBuilt 2002 · S/N 172S9226 N5290HLevy James L · Clifton Park, NYBuilt 2002 · S/N 172S9230 N5290VSpartan Education LLC · Tulsa, OKBuilt 2010 · S/N 172S11025 N5291ALewis Aeronautical LLC · San Antonio, TXBuilt 2009 · S/N 172S11021 N5291WMaxxum Financial Group Inc · Destrehan, LABuilt 2002 · S/N 172S9234 N5294WSonneborn Arthur Aaron · East Leroy, MIBuilt 2003 · S/N 17281186 N5296DZack Gary J · Sunderland, VTS/N 172S9239 N5296ZSouthern Sky LLC · Henderson, NVBuilt 2002 · S/N 172S9241 N5297EAtd Pilot Training LLC · Kansas City, MOBuilt 2002 · S/N 172S9242 N5297GChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9243 N5298NJ3m Airops LLC · Daytona Beach, FLBuilt 2002 · S/N 172S9244 N5298SSix Ten Ventures LLC · Grand Prairie, TXBuilt 2002 · S/N 172S9246 N529ERPs N529er LLC · Green Bay, WIBuilt 2002 · S/N 172S9111 N529NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10981 N529PTLt Express LLC · Carson City, NVBuilt 2002 · S/N T18208119 N52HAAssociated Packaging Inc · Gallatin, TNS/N 18282226 N52LULetourneau University · Longview, TXBuilt 2024 · S/N 172S13198 N52TMJorgensen Aviation Inc · Richfield, UTBuilt 2019 · S/N 18283080

Back to AD 2005-05-53 R1