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.

N6025DMorgan Joel E · Mcalester, OKBuilt 2006 · S/N 18281830 N6025EVictor Air LLC · Kirkland, WABuilt 2006 · S/N T18208565 N6025FLeeloo Air LLC · Reno, NVBuilt 2006 · S/N T18208566 N6025PThagair LLC · Reno, NVBuilt 2006 · S/N T18208567 N6025ZWind River Aviators LLC · Dubois, WYBuilt 2006 · S/N T18208568 N6026SPhoneix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10206 N6026ZAerodynamic LLC · Aurora, ORBuilt 2006 · S/N 172S10208 N60279Tensco Inc · Twin Falls, IDBuilt 2006 · S/N 18281804 N6027ZSpacely Space Sprockets LLC · Aurora, ORBuilt 2006 · S/N 172S10159 N6028UDesert Sky Aviation LLC · La Quinta, CABuilt 2006 · S/N T18208538 N6028YPuerto Rico Aircraft Leasing Corp · Ceiba, PRBuilt 2006 · S/N 172S10173 N602CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 18283072 N602EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12698 N602NDRainer Flight Service LLC · Renton, WABuilt 2012 · S/N 172S11253 N602TCSanderson Kimberly L · Swartz, LABuilt 2000 · S/N 172S8383 N602TLCoast Flight Training And Management Inc · San Diego, CABuilt 2008 · S/N 172S10736 N6031LRegistered aircraftBuilt 2006 · S/N 172S10188 N6031WWings Over Texas Holdings LLC · Denton, TXBuilt 2006 · S/N 172S10189 N6032DBravo Gulf Zulu Aviation LLC · Newark, DEBuilt 2006 · S/N 18281820 N6032THard Times Wy LLC · Helena, MTBuilt 2006 · S/N T18208554 N6032WKolb Jonah Allan · Underhill, VTBuilt 2006 · S/N T18208555 N60337Lewis University · Romeoville, ILBuilt 2006 · S/N 172S10192 N6033BRmp Management Co Inc · Rancho Cucamonga, CABuilt 2006 · S/N T18208559 N6033SSuburban Air Corp · Castro Valley, CABuilt 2006 · S/N 172S10191 N60349Mb Aviation LLC · Mount Pleasant, TXBuilt 2006 · S/N T18208562 N6034BFxe Flightcenter Corp · Fort Lauderdale, FLBuilt 2006 · S/N 172S10193 N6034DDuro Vincent · Highland, CABuilt 2006 · S/N 172S10195 N6034FToth Norman J · Spring Hill, FLBuilt 2006 · S/N 172S10196 N6034ZN6034z LLC · Missoula, MTBuilt 2006 · S/N T18208560 N60356Gray Family Acquisitions LLC · Loomis, CABuilt 2006 · S/N T18208571 N6035ALandrys Aviation Services LLC · Pierre Part, LABuilt 2006 · S/N T18208563 N6035HExclusive Auto'S LLC · Preston, IDS/N T18208564 N60363Cumulus Aviation Services LLC · Port Orange, FLBuilt 2006 · S/N 172S10215 N6036AClive Consulting LLC · Dover, DEBuilt 2006 · S/N T18208573 N6036YChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10213 N60372Above And Beyond Aviation LLC · Austin, TXBuilt 2006 · S/N 172S10216 N6038VEdb Air Inc · Wilsonville, ORBuilt 2006 · S/N 18281832 N60395American Aviation Inc · Brooksville, FLBuilt 2006 · S/N 172S10226 N60397Vector USA LLC · Olive Branch, MSBuilt 2006 · S/N 172S10227 N60398Wagoner Aviation LLC · Clovis, CABuilt 2006 · S/N 18281834 N6039HMailing And Fulfilling America Inc · Fort Worth, TXFirst renewal noticeBuilt 2006 · S/N T18208581 N603EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12701 N603NDFm Aviation Services LLC · Arlington, VABuilt 2012 · S/N 172S11254 N6040CZach Air Corp · Byfield, MAS/N 18281835 N6040GPineland Holdings LLC · Gibsland, LABuilt 2006 · S/N 18281836 N6040STait Layne S · Bloomington, INBuilt 2006 · S/N T18208589 N6042NCal Aggie Flying Farmers · Davis, CABuilt 2006 · S/N 172S10228 N6042ZL&G Skycatcher LLC · Bradenton, FLBuilt 2006 · S/N 172S10230 N60430County Of Henrico Virginia · Henrico, VABuilt 2006 · S/N 18281839 N60435Georgia Forestry Commission · Macon, GABuilt 2006 · S/N 18281840

Back to AD 2005-05-53 R1