OpenAirDocs.org
AD 83-17-05

Registered aircraft · 39

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

N107JSSayers James B · Edison, OHBuilt 1975 · S/N CJ-88N14JPDakota Aircraft Inc · Pierre, SDBuilt 1986 · S/N CJ-177N153SPRegistered aircraftN-number assigned, not yet registeredS/N CJ-24N160UCrane Rental Service Inc · Tempe, AZBuilt 1960 · S/N CJ-9N1KYCatherines Aviation Services LLC · Sewanee, TNBuilt 1968 · S/N CJ-3N233CNw Beech Boys LLC · Everson, WABuilt 1969 · S/N CJ-18N249ASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N CJ132N249WHWhiskey Hotel LLC · O Fallon, MOBuilt 1978 · S/N CJ-147N249WLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N CJ-134N277FRowland Maxwell J · League City, TXBuilt 1969 · S/N CJ-16N30RFBonsal John R · Flower Mound, TXBuilt 1978 · S/N CJ-142N34JPDakota Aircraft Inc · Pierre, SDBuilt 1973 · S/N CJ-39N377RFGlobal Flight Support And Sales Inc · Tampa, FLBuilt 1987 · S/N CJ179N4376RMoore Michael J · Mountain Brk, ALBuilt 1969 · S/N CJ-14N447NASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N CJ-130N455DCAviation Safety Training International LLC · Butte, MTBuilt 1968 · S/N CJ-13N533C71sq Inc · Wilmington, DEBuilt 1978 · S/N CJ135N544STGordon Jonathan · Bronxville, NYBuilt 1969 · S/N CJ-22N5552Rosenlof Dean F · Tempe, AZBuilt 1969 · S/N CJ-15N58MCTubreaux Aviation Services LLC · Shreveport, LABuilt 1978 · S/N CJ-143N657VSPuccio Serge · Houston, TXS/N CJ-4N65SH65 Sierra Hotel LLC · Wilmington, DEBuilt 1970 · S/N CJ-28N669KMAviation Consultants Inc · Wilmington, DES/N CJ139N720DWCatalina Sierra Inc · Wilmington, DEBuilt 1970 · S/N CJ-30N73FPDunn Frederick C Jr · Fayetteville, GABuilt 1968 · S/N CJ-5N7732RAluzion LLC · Madison, ALBuilt 1968 · S/N CJ-7N7735RJavelin Banana LLC · Erda, UTBuilt 1968 · S/N CJ-8N7741R41 Romeo LLC · Eatonton, GABuilt 1968 · S/N CJ-10N775JWCunningham William R · Broken Arrow, OKBuilt 1968 · S/N CJ-2N77ABEmap Aviation LLC · Tavernier, FLBuilt 1968 · S/N CJ-12N7853RHarrell Erick C · Sedona, AZS/N CJ-17N7913RBeadle Steve E · El Paso, TXBuilt 1969 · S/N CJ-19N7927RN7927r LLC · Columbia Falls, MTBuilt 1969 · S/N CJ-20N79MMMartin Martha S · Graford, TXBuilt 1969 · S/N CJ-21N808TSGross Andrew · Mooresville, NCBuilt 1968 · S/N CJ-1N8112RWest Richard E · Albuquerque, NMBuilt 1969 · S/N CE-262N8176REpps Elaine · Atlanta, GABuilt 1974 · S/N CJ-53N8189RMayer Bari S · Austin, TXBuilt 1974 · S/N CJ-56N851KProtac Aviation LLC · Jackson, WYBuilt 1986 · S/N CJ-178
Back to AD 83-17-05