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.

N103SLAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 1985 · S/N 11735N104DTDavis Brenda Kruszewski · Middleton, IDBuilt 1981 · S/N 96010N108SAFlying A Flight Service LLC · Safford, AZBuilt 1977 · S/N 11416N112EESpur Aviation Services Lc · Twin Falls, IDBuilt 1976 · S/N 11330N121JWGlobal Jet LLC · Missoula, MTBuilt 1975 · S/N 11299N125MMFox Tango Tango Inc · Houston, TXBuilt 1979 · S/N 11605N127HJPonderosa Aviation LLC · Safford, AZBuilt 1978 · S/N 11467N12VAAirborne Research LLC · Fort Pierce, FLS/N 96062N13RABarney Adam Joseph · Altamonte Springs, FLBuilt 1975 · S/N 11235N1420VCommander Trust LLC · Fort Lauderdale, FLBuilt 1979 · S/N 11524N15CDCommander N15cd LLC · Miami, FLS/N 11177N15SFKolob Canyons Air Services Inc · Wilmington, DEBuilt 1979 · S/N 11528N162ALNeptune Aviation Services Inc · Missoula, MTBuilt 1975 · S/N 11231N167RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1978 · S/N 11437N186EOmeara John S Trustee · Newport Beach, CABuilt 1979 · S/N 11566N192LHHill Lawrence E · Marion, MTS/N 95019N197GBPonderosa Aviation LLC · Safford, AZBuilt 1975 · S/N 11282N20MAOberon Management LLC · Fort Smith, ARBuilt 1978 · S/N 11514N2141BAmhurst Development Inc · Lewes, DEBuilt 1978 · S/N 11484N218MSSasha Air LLC · Hingham, MABuilt 1981 · S/N 95041N222MEClearwater Airco LLC · Anchorage, AKS/N 11338N224EZMarjo Ventures Inc · Key West, FLS/N 96206N225MMJ & M Aircraft Holding LLC · Bellaire, TXBuilt 1978 · S/N 11462N225TDCat Air LLC · Melba, IDBuilt 1980 · S/N 11635N231AVTeton Leasing LLC · Pocatello, IDBuilt 1977 · S/N 11353N245CFEagle Creek Aviation Services Inc · Indianapolis, INBuilt 1976 · S/N 11313N24GTPia Avcenter LLC · Peoria, ILBuilt 1975 · S/N 11254N251ESLumphanan LLC · Adams, NEBuilt 1975 · S/N 11251N25CEKoy Dean R · Houston, TXBuilt 1977 · S/N 11400N2609PNtail LLC · Sheridan, WYBuilt 1979 · S/N 11617N260WEFlying A Flight Service LLC · Safford, AZBuilt 1979 · S/N 11536N267RDReisen LLC · Stevensville, MTBuilt 1978 · S/N 11456N29GADelaurentis Robert Gerard · San Diego, CABuilt 1983 · S/N 15025N29GDAriel Seafoods Aviation LLC · Destin, FLBuilt 1983 · S/N 15035N30854Cornerstone Financial Enterprises LLC · Mesquite, NVS/N 11229N31BVCourtney Aviation LLC · Columbia, CAS/N 11315N32ALAero Air LLC · Hillsboro, ORBuilt 1976 · S/N 11336N32GASpur Aviation Services Lc · Twin Falls, IDBuilt 1974 · S/N 11215N32WSPonderosa Aviation LLC · Safford, AZBuilt 1976 · S/N 11339N333UPEverel Airborne LLC · Sandia Park, NMS/N 96015N362SHFlight-Plan One LLC · Bay City, MIBuilt 1976 · S/N 11316N364WAAerokinetical Aviators LLC · West Chester, OHBuilt 1977 · S/N 11439N36JFMmdex LLC · Carlisle, PABuilt 1978 · S/N 11478N36JTAerial Surveys International LLC · Watkins, COBuilt 1980 · S/N 95-024N37SBZb Investments Ltd · Dallas, TXS/N 11724N383HCAc690 LLC · Alpine, WYBuilt 1975 · S/N 11310N3869FElkhorn Aviation Inc · Baker City, ORBuilt 1973 · S/N 11141N38LMKoy Dean · Houston, TXBuilt 1977 · S/N 11424N38WAAirborne Support Inc · Houma, LABuilt 1974 · S/N 11169N3NTSpur Aviation Services Lc · Twin Falls, IDBuilt 1983 · S/N 15037
Back to AD 87-24-07 R1