AD 80-10-01

Registered aircraft · 2,613

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

N112SSOlsen John · Wasilla, AKS/N 18052510N113BHBighorn Airways Inc · Sheridan, WYBuilt 1967 · S/N 18051844N113LCLcd Aviation Corp · Wilmington, DEBuilt 1969 · S/N 185-1459N113TBBeaudoin Todd · Castleton, NYS/N 18503772N1145FGurke George J · Anchorage, AKBuilt 1975 · S/N 18502757N115AWMillican Marc J · Anchorage, AKBuilt 1976 · S/N 18502941N11669Cummings Arthur · Delta Junction, AKBuilt 1963 · S/N 185-0493N1169QRohde Allen G · Eagle River, AKBuilt 1977 · S/N 18503466N116AKLucas Kelly W · Wasilla, AKBuilt 1965 · S/N 18051469N1177SRoss Robert S · Pigeon, MIBuilt 1958 · S/N 50177N1185Wahlers Richard H · Meridian, IDBuilt 1971 · S/N 18501931N1185TBelanger Ernest E · Wasilla, AKS/N 18501971N118ARegistration Pending · Shasta, CARegistration pendingBuilt 1977 · S/N 18503339N118RABroken Aero Inc · Dunnellon, FLBuilt 1967 · S/N 18051935N1197FSchumacher Bradley M · Lewiston, IDBuilt 1975 · S/N 18502763N119DSDeltasierra LLC · Staunton, VABuilt 1979 · S/N 18503735N119WCSmith Steven W · Kodiak, AKBuilt 1972 · S/N 18052235N11ATChan Roger J · Anchorage, AKBuilt 1974 · S/N 18502547N11CSilicz Nicholas J · Shafter, CABuilt 1975 · S/N 18502713N11CEMelcher Pierre S · New Braunfels, TXBuilt 1974 · S/N 18502512N11HHRegistration Pending · Durango, CORegistration pendingBuilt 1965 · S/N 18051484N1204FMoroney Aviation LLC · Chugiak, AKBuilt 1975 · S/N 18502767N1206FHarrah Daniel R · Juneau, AKBuilt 1975 · S/N 18502769N1208FYukon Air Service Inc · Fairbanks, AKBuilt 1975 · S/N 18502771N1211FGarner Greg A · Renton, WABuilt 1975 · S/N 18502774N1217FUnited States Department Of Interior · Boise, IDBuilt 1975 · S/N 18502779N121EESheldon Air Service LLC · Anchorage, AKBuilt 1979 · S/N 18503765N121KSCa-C180j LLC · Addison, TXBuilt 1976 · S/N 18052683N121RDVickery Forest H · Tallahassee, FLS/N 18052053N1222FVelocity Sport LLC · Cedar Falls, IABuilt 1975 · S/N 18502784N1225QDupont Larry W · North Hero, VTBuilt 1977 · S/N 18503472N1227FPeterson Investments Inc · Polson, MTBuilt 1975 · S/N 18502789N122VCTurner Terrance A · Anchorage, AKBuilt 1973 · S/N 18502203N1231FRegistration Pending · Wasilla, AKRegistration pendingBuilt 1975 · S/N 18502793N1232FLloyd Land Plane I LLC · Brighton, COBuilt 1975 · S/N 18502794N1234YDe Jong Thomas · Buckeye, AZBuilt 1980 · S/N 18503944N1236FPitcher Michael C · Mancelona, MIS/N 18502796N1237Fraser Mark L · Fairfield, CABuilt 1980 · S/N 18504021N1239FValpey R Wesley Jr · Medford, MEBuilt 1975 · S/N 18502799N123EPFalkenberg Randy J · Edmonson, TXBuilt 1976 · S/N 185-03216N123LJRegistered aircraftBuilt 1965 · S/N 18051526N124LRWilson David J · Palmer, AKBuilt 1970 · S/N 18501639N124UAKagerer John A Trustee · Anchorage, AKBuilt 1976 · S/N 18503022N1250WScherff Lewis H Trustee · Inver Grove, MNBuilt 1964 · S/N 18051429N1251BJagow Charles Philip · Fairbanks, AKBuilt 1966 · S/N 18051756N1253QLibbyn The Dream Fishing Team LLC · Anchorage, AKS/N 18503473N12580White River Ag Spraying Llp · Newport, ARBuilt 1964 · S/N 18051458N125KTRustair Inc · Anchorage, AKBuilt 1977 · S/N 18503494N126AKRohl Shirley J · Anchorage, AKBuilt 1957 · S/N 32772N126MSNance Cattle Co · Birney, MTBuilt 1964 · S/N 18051373
Back to AD 80-10-01