OpenAirDocs.org
AD 89-07-07 R1

Registered aircraft · 673

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:89-07-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:89-07-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.

N690CFN A Corp · Scappoose, ORBuilt 1974 · S/N 11168N690CPPonderosa Aviation LLC · Safford, AZBuilt 1978 · S/N 11451N690DDTropeano Construction Inc · Ocala, FLBuilt 1974 · S/N 11159N690GFBank Of Utah Trustee · Salt Lake City, UTBuilt 1976 · S/N 11357N690HBPonderosa Aviation LLC · Safford, AZBuilt 1974 · S/N 11205N690PLMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2004 · S/N 2N690PTCritical Mass Aviation LLC · Coral Springs, FLBuilt 1975 · S/N 11252N690SDWoodward Properties LLC · Kalispell, MTBuilt 1975 · S/N 11287N690SGNeptune Aviation Services Inc · Missoula, MTBuilt 1974 · S/N 11146N690TRKolob Canyons Air Services Inc · Wilmington, DEBuilt 1972 · S/N 11034N690WWBemidji Aviation Services Inc · Bemidji, MNBuilt 1987 · S/N AC690BN691AXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1987 · S/N AC-691N692TKaskel Super Service LLC DBA · Evansville, INBuilt 1979 · S/N 11555N695FABank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 96077N695GHN695gh Inc Trustee · Wilmington, DES/N 96078N695JPGulfcomm 1000 LLC · Matthews, NCS/N 96024N695MMM8 Aviation LLC · Raleigh, NCBuilt 1982 · S/N 96050N695RTCommander 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 96089N699RKDynamic Aircraft Consortium LLC · Tangent, ORBuilt 1979 · S/N T300N700AAJensen Jay A · Bountiful, UTBuilt 2004 · S/N 1N700BAAviation Inventory Resources Inc · Alvarado, TXBuilt 1980 · S/N BE-84N700DALowrey Jonathan S · Jasper, INBuilt 1969 · S/N 140N700WAJohnson William M · Wichita, KSBuilt 1979 · S/N 400SAN7065DValley Air Service · Caldwell, IDBuilt 1993 · S/N 1Z024-15N708PCAustin Point Aviation LLC · Portland, ORBuilt 1980 · S/N 95023N709TRAmeriflight LLC · Dfw Airport, TXS/N AC-709BN70PEGst Aviation LLC · Tucson, AZBuilt 1979 · S/N 416 S.A.N70WYBecker Flying Service Inc · Hartington, NEBuilt 1995 · S/N G6-127N711MBBarrick Gold Of North America Inc · Henderson, NVBuilt 1979 · S/N 441-0116N711VKDuggar Aviation LLC · Tontitown, ARBuilt 1969 · S/N 157N716CCRichmond Wheeler LLC · Marshfield, WIBuilt 1981 · S/N 441-0213N716SMConquest Flight LLC · Pottstown, PABuilt 1977 · S/N 441-0004N718EEN718ee LLC · Missoula, MTBuilt 1978 · S/N 718SAN725JTCorsair Enterprises Inc · Wilmington, DEBuilt 1981 · S/N 451 S.A.N725SVTtc Aircraft Leasing Inc · Decatur, TXBuilt 1978 · S/N 441-0051N727DPTvpx Aircraft Solutions Inc Owner Trustee · North Salt Lake, UTS/N AT039N727TPAudubon Air Of Louisiana LLC · Bossier City, LABuilt 1981 · S/N 1517SAN728FNAustin Bill DBA · Sparta, TNS/N 303N731EAlaskan Air Charter LLC · Anchorage, AKBuilt 1968 · S/N SH-1853N731TFTwo Friends Leasing LLC · Key West, FLBuilt 1979 · S/N T321N733BHCareer Aviation Company Inc · Wilmington, DEBuilt 1989 · S/N AC-733BN741FNAir 1st Aviation Co Of Ok · Tulsa, OKBuilt 1975 · S/N 658N746KAKolob Canyons Air Services Inc · Wilmington, DEBuilt 1989 · S/N AC 746 BN746MAPacific Aircraft Services LLC · Saint Helens, ORS/N 136746N7501EFranklin Dirk W · Beaumont, TXBuilt 1987 · S/N 794BN750CAQualitair LLC Trustee · MichchelstadtBuilt 1979 · S/N 407SAN751BRPonderosa Aviation LLC · Safford, AZBuilt 1977 · S/N 11436N751TRCareer Aviation Company Inc · Wilmington, DEBuilt 1989 · S/N AC751B
Back to AD 89-07-07 R1