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.

N690BHHoward Bradley D · Big Sky, MTS/N 11361N690BMCommander 690 Bm LLC · Manassas, VABuilt 1975 · S/N 11311N690CCTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1977 · S/N 11379N690CFN A Corp · Scappoose, ORBuilt 1974 · S/N 11168N690CHElecrock LLC · Bay City, WIBuilt 1979 · S/N 11542N690CPPonderosa Aviation LLC · Safford, AZBuilt 1978 · S/N 11451N690DDTropeano Construction Inc · Ocala, FLBuilt 1974 · S/N 11159N690EHSanborn Map Company Inc · Colorado Springs, COBuilt 1975 · S/N 11309N690FDPonderosa Aviation LLC · Safford, AZBuilt 1977 · S/N 11393N690GFBank Of Utah Trustee · Salt Lake City, UTBuilt 1976 · S/N 11357N690HBPonderosa Aviation LLC · Safford, AZBuilt 1974 · S/N 11205N690HFRegistered aircraftBuilt 1975 · S/N 11298N690JKSpur Aviation Services Lc · Twin Falls, IDBuilt 1978 · S/N 11480N690LNSanborn Map Company Inc · Colorado Springs, COBuilt 1977 · S/N 11415N690PKMilou 1 LLC · New York, NYS/N 11166N690PTCritical Mass Aviation LLC · Coral Springs, FLBuilt 1975 · S/N 11252N690RAMountain Aviation Enterprises LLC · Safford, AZBuilt 1972 · S/N 11010N690RJAir Prometheus LLC · Santa Fe, NMS/N 11508N690SDWoodward Properties LLC · Kalispell, MTBuilt 1975 · S/N 11287N690SESkyline Enterprises Corp · Miramar, FLBuilt 1978 · S/N 11463N690SGNeptune Aviation Services Inc · Missoula, MTBuilt 1974 · S/N 11146N690TGNeptune Aviation Services Inc · Missoula, MTBuilt 1976 · S/N 11319N690TRKolob Canyons Air Services Inc · Wilmington, DEBuilt 1972 · S/N 11034N690WS69 Whiskey LLC · Nezperce, IDBuilt 1974 · S/N 11194N692TKaskel Super Service LLC DBA · Evansville, INBuilt 1979 · S/N 11555N695CSCourtney 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 96089N699SBMeginnis Thomas O · Omaha, NEBuilt 1976 · S/N 11280N700PQPia Avcenter LLC · Peoris, ILBuilt 1977 · S/N 11389N708PCAustin Point Aviation LLC · Portland, ORBuilt 1980 · S/N 95023N711PBSpur Aviation Services Lc · Twin Falls, IDBuilt 1976 · S/N 11356N71AAFlying A Flight Service LLC · Safford, AZBuilt 1979 · S/N 11527N721TBTeton Leasing LLC · Pocatello, IDBuilt 1976 · S/N 11352N74EF3bk Source LLC · Wellington, FLBuilt 1979 · S/N 11614N751BRPonderosa Aviation LLC · Safford, AZBuilt 1977 · S/N 11436N75UFive Uniform LLC · Ooltewah, TNS/N 11218N76ECAltair Aircraft LLC · Gainesville, FLS/N 11208N76WAFlying A Flight Service LLC · Safford, AZBuilt 1976 · S/N 11342N771BAInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N 11429N771FFChandler Energy LLC · Denver, COBuilt 1982 · S/N 15014N77HSCourtney Aviation LLC · Columbia, CABuilt 1985 · S/N 15041
Back to AD 87-24-07 R1