OpenAirDocs.org
AD 87-24-07 R1

Registered aircraft · 206

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:87-24-07-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:87-24-07-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.

N78NASpur Aviation Services Lc · Twin Falls, IDBuilt 1977 · S/N 11401N78TTCove Pointe Air LLC · Adrian, MIBuilt 1978 · S/N 11509N79BEPonderosa Aviation LLC · Safford, AZS/N 11408N79PHMaxus Capital Group LLC · Cleveland, OHS/N 96029N800VBAerial Surveys International LLC · Watkins, COBuilt 1980 · S/N 11646N80PHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N 11691N823SBPia Avcenter LLC · Peoria, ILBuilt 1975 · S/N 11304N840AKState Of Alaska · Palmer, AKBuilt 1980 · S/N 11643N840AMQueen Enterprises LLC · Wilmington, DES/N 11709N840BDDash One LLC · Newbury, NHS/N 11659N840CFPappusgrass Aviation LLC · San Antonio, TXBuilt 1980 · S/N 11624N840EETmc840 LLC · Bluffton, SCS/N 11729N840GHCrescent Valley Baling LLC · Corvallis, ORBuilt 1979 · S/N 11615N840JWRepax LLC · Erie, PABuilt 1981 · S/N 11658N840MD&G Aviation LLC · Denver, COBuilt 1980 · S/N 11657N840PNWest Transportation LLC · West Bloomfield, MIBuilt 1981 · S/N 11679N840PSChs Leasing LLC · Boca Raton, FLBuilt 1981 · S/N 11672N840RBGreat American Jet Inc · Cincinnati, OHBuilt 1981 · S/N 11699N840SEGreen Fairways Florida Inc · Key West, FLBuilt 1979 · S/N 11610N840TWNeptune Aviation Services Inc · Missoula, MTBuilt 1981 · S/N 11689N844CHFlying H Enterprises LLC · Scottsdale, AZBuilt 1978 · S/N 11470N848CECourtney Aviaton LLC · Columbia, CABuilt 1975 · S/N 11303N848LGPia Avcenter LLC · Peoria, ILBuilt 1980 · S/N 11641N84GUPagosa Air Charter LLC · Pagosa Springs, COBuilt 1979 · S/N 11522N850ACInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 11629N880GGarlynson Airways LLC · Lincoln, NEBuilt 1980 · S/N 95033N887SDTesoro Capital LLC · High Point, NCBuilt 1984 · S/N 96207N892WATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1976 · S/N 11273N8PQElkhorn Aviation Inc · Baker City, ORBuilt 1975 · S/N 11243N900PWAbf Aviation LLC · Stephenville, TXBuilt 1984 · S/N 15033N901TECheviot Holdings LLC · Key Largo, FLBuilt 1983 · S/N 15031N905AKState Of Alaska · Palmer, AKS/N 96063N90ATKolob Canyons Air Services Inc · Wilmington, DEBuilt 1975 · S/N 11272N910FCSanborn Map Co Inc · Colorado Springs, COBuilt 1981 · S/N 11682N911KCCounty Of Kern · Bakersfield, CABuilt 1975 · S/N 11300N913NL2242 Enterprises LLC · Dover, DES/N 15008N926SCCone S E Jr · Hobbs, NMBuilt 1980 · S/N 11622N927SMHamm Equipment Inc · Casper, WYS/N 15013N93MEPonderosa Aviation LLC · Safford, AZBuilt 1977 · S/N 11414N947LMAltisimo LLC · West Palm Beach, FLBuilt 1982 · S/N 15015N94EA63nl LLC · Willmar, MNBuilt 1985 · S/N 96094N95ABRidgeaire Inc · Jacksonville, TXS/N 96012N95JMRemington Aerospace LLC · Chandler, AZBuilt 1975 · S/N 11289N95LFNeptune Aviation Services Inc · Missoula, MTBuilt 1975 · S/N 11290N969TDThompson Builders Corp · Novato, CABuilt 1983 · S/N 15032N980AETj Air Holdings Inc Trustee · Wilmington, DEBuilt 1981 · S/N 95078N980AKUniversal Pacific Investment Corporation · Portland, ORBuilt 1980 · S/N 11636N980BHKellogg Consulting LLC · San Antonio, TXBuilt 1980 · S/N 95002N980CWWells & West Inc · Murphy, NCS/N 95013N980EEPlane Fun Inc Tr Trustee · Snellville, GABuilt 1980 · S/N 95039
Back to AD 87-24-07 R1