OpenAirDocs.org
AD 2003-07-03

Registered aircraft · 37

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
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:2003-07-03')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-07-03')
  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.

N104DTDavis Brenda Kruszewski · Middleton, IDBuilt 1981 · S/N 96010N12VAAirborne Research LLC · Fort Pierce, FLS/N 96062N224EZMarjo Ventures Inc · Key West, FLS/N 96206N29GADelaurentis Robert Gerard · San Diego, CABuilt 1983 · S/N 15025N29GDAriel Seafoods Aviation LLC · Destin, FLBuilt 1983 · S/N 15035N333UPEverel Airborne LLC · Sandia Park, NMS/N 96015N3NTSpur Aviation Services Lc · Twin Falls, IDBuilt 1983 · S/N 15037N444WDFlyto LLC · Indianapolis, INBuilt 1988 · S/N 96006N479PTT Enterprises Inc · Jackson, MSBuilt 1981 · S/N 96011N51DMJersey Ordnance Inc · Westampton, NJBuilt 1981 · S/N 96014N601WTNickel Family LLC · Bakersfield, CABuilt 1982 · S/N 15016N67WGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1982 · S/N 96052N695CSCourtney Aviation LLC · Columbia, CAS/N 96007N695FABank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 96077N695GHN695gh Inc Trustee · Wilmington, DES/N 96078N695GKGulfstream Aviation LLC · West Glacier, MTBuilt 1982 · S/N 96032N695JHCommander LLC · Sun Valley, IDS/N 96096N695JPGulfcomm 1000 LLC · Matthews, NCS/N 96024N695MMM8 Aviation LLC · Raleigh, NCBuilt 1982 · S/N 96050N695RCCapital Aviation II LLC · Bethesda, MDS/N 96087N695RTCommander Sc LLC · Mount Pleasant, SCBuilt 1986 · S/N 96208N695TRRainey Air LLC · Bronwood, GABuilt 1982 · S/N 96034N695ZSanborn Map Company Inc · Colorado Springs, COBuilt 1984 · S/N 96089N771FFChandler Energy LLC · Denver, COBuilt 1982 · S/N 15014N77HSCourtney Aviation LLC · Columbia, CABuilt 1985 · S/N 15041N79PHMaxus Capital Group LLC · Cleveland, OHS/N 96029N887SDTesoro Capital LLC · High Point, NCBuilt 1984 · S/N 96207N900PWAbf Aviation LLC · Stephenville, TXBuilt 1984 · S/N 15033N901TECheviot Holdings LLC · Key Largo, FLBuilt 1983 · S/N 15031N905AKState Of Alaska · Palmer, AKS/N 96063N913NL2242 Enterprises LLC · Dover, DES/N 15008N927SMHamm Equipment Inc · Casper, WYS/N 15013N947LMAltisimo LLC · West Palm Beach, FLBuilt 1982 · S/N 15015N94EA63nl LLC · Willmar, MNBuilt 1985 · S/N 96094N95ABRidgeaire Inc · Jacksonville, TXS/N 96012N969TDThompson Builders Corp · Novato, CABuilt 1983 · S/N 15032N9942SHarvey Jerry L · Pompano Beach, FLS/N 96022
Back to AD 2003-07-03