OpenAirDocs.org
AD 75-12-09 R2

Registered aircraft · 245

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

N777VMAbbing Frits G H · Crescent City, FLS/N 520-125N78345Peter Claire Ltd · George TownBuilt 1962 · S/N 500B-1237-107N78379Bottrell John E II · Yukon, OKBuilt 1962 · S/N 500A-1265-88N787RKEpitrop Foundation · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1968 · S/N 1832-29N799CERed Oar Aviation LLC · Lookout Mountain, TNS/N 1807-17N7ACCommander Quest LLC · San Luis Obispo, CABuilt 1961 · S/N 500B-1013-34N800ACTango Gulf LLC · Naples, FLBuilt 1962 · S/N 500A-1193-65N800TTwin Aviation LLC · Coushatta, LABuilt 1960 · S/N 98633N801DPSunset Aviation Services LLC · Coeur D Alene, IDBuilt 1960 · S/N 500B-999-30N801KPlumlee James H · Bluffton, SCBuilt 1961 · S/N 500B-1094-57N811DKucheck Alan · Yucca Valley, CAS/N 500A-1256-80N811PJObrien Neal J · Milton, GABuilt 1969 · S/N 3051N818TECentral Airlines Inc · Leawood, KSBuilt 1960 · S/N 500B-995-26N8445CMaddox Jody S · Paterson, WABuilt 1959 · S/N 680E-777-49N8460CState Of Alaska Dept Of Fish & Game · Kodiak, AKBuilt 1959 · S/N 500-799N8468CIntravaia Anthony J · Mountain View, CABuilt 1959 · S/N 680E-802-57N8498CAir Margarita · San Juan, PRBuilt 1960 · S/N 848N8536Bosco74 LLC · Wilmington, DEBuilt 1975 · S/N 3267N887BDBolin Industries · Hamburg, ARBuilt 1963 · S/N 1249-74N8LXAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1969 · S/N 3065N9080NBoeing Co · Renton, WABuilt 1969 · S/N 3066N9096NStones River Aviation LLC · Murfreesboro, TNBuilt 1969 · S/N 3076N90JPAec Shrike LLC · Barrington, ILBuilt 1970 · S/N 3078N9135NAdriaans Cornelus A · Wittmann, AZS/N 1269-92N9159NBoeing Co · Renton, WABuilt 1971 · S/N 3113N915PRAvialogia Inc · CancunS/N 3126N9160NBoeing Co · Renton, WABuilt 1971 · S/N 3114N9177Chaffin Christopher · Flower Mound, TXBuilt 1972 · S/N 3125N917GTCentral Airlines Inc · Leawood, KSBuilt 1960 · S/N 500B-983-24N9186NShrike One LLC · Deerfield Beach, FLBuilt 1972 · S/N 3131N922BSCentral Airlines Inc · Leawood, KSBuilt 1966 · S/N 1598-207N929JMCalhoun Paul M · Larue, TXS/N 3319N9383RSmith Casey B · Springer, OKS/N 905-14N9397RRock Douglas A · Bloomington, INBuilt 1961 · S/N 500A-1008-36N9399RJenkins Patrick · Pleasant View, TNBuilt 1960 · S/N 500B9174N957JACbmw LLC · Wise, VABuilt 1978 · S/N 3308N95ARPfaff Ben J · Bend, ORBuilt 1962 · S/N 500A-1270-93N961SCVadnais Kenneth G · Santa Barbara, CABuilt 1975 · S/N 3235N965ARRubio Brunet Pedro Angel · Mulberry, FLS/N 1195-100N9680EMulkey Howard Daniel · Spanaway, WAS/N 699-18N975AAEmez Holdings LLC · Boca Raton, FLBuilt 1974 · S/N 3175N999DATowner Andrew J Trustee · Leawood, KSS/N 3290N999GBPlane Services LLC · Twin Falls, IDS/N 1717-27N99LQTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1959 · S/N 834N9QYAmelia Air LLC · Naples, FLBuilt 1979 · S/N 3321
Back to AD 75-12-09 R2