AD 75-09-06

Registered aircraft · 1,624

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-09-06')
    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-09-06')
  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.

N119DSDeltasierra LLC · Staunton, VABuilt 1979 · S/N 18503735N11ATChan Roger J · Anchorage, AKBuilt 1974 · S/N 18502547N11CSilicz Nicholas J · Shafter, CABuilt 1975 · S/N 18502713N11CEMelcher Pierre S · New Braunfels, TXBuilt 1974 · S/N 18502512N1204FMoroney 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 18503765N1222FVelocity 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-03216N124LRWilson David J · Palmer, AKBuilt 1970 · S/N 18501639N124UAKagerer John A Trustee · Anchorage, AKBuilt 1976 · S/N 18503022N1253QLibbyn The Dream Fishing Team LLC · Anchorage, AKS/N 18503473N125KTRustair Inc · Anchorage, AKBuilt 1977 · S/N 18503494N1282FRainbow River Lodge Aviation LLC · Alpine, UTS/N 18502806N1285FWill Rittner E · Sevierville, TNBuilt 1975 · S/N 18502809N1286FTaylor Aviation Inc · Mazama, WAFirst renewal noticeBuilt 1975 · S/N 18502810N1292FRustair Inc · Anchorage, AKBuilt 1975 · S/N 18502668N1296FWalker Brandon · Anchorage, AKBuilt 1975 · S/N 18502816N129KTFowler Andy D · Anchorage, AKBuilt 1975 · S/N 18502812N129LPJag Aviation LLC · Belle Chasse, LABuilt 1980 · S/N 18504088N129MLarkin Marion J · Salome, AZBuilt 1973 · S/N 18502208N129PRRasmussen Paul B · Long Lake, NYBuilt 1968 · S/N 185-1448N12ASNewman Scott W · Healdsburg, CABuilt 1973 · S/N 18502271N12DMIsland Airways LLC · Marion, WIBuilt 1976 · S/N 18502947N1322FHoffman Michael J · Bethel, AKBuilt 1975 · S/N 18502825N135NCBalocco Mark E · Sparks, NVBuilt 1980 · S/N 18503992N1362FOldham Kris D · Anchorage, AKBuilt 1975 · S/N 18502834N1370QEvans Randall B Trustee · Fallon, NVBuilt 1977 · S/N 18503480N1373FBaczewski Gary L · San Antonio, TXBuilt 1975 · S/N 18502837N137LKStubby Wings LLC · Eden Prairie, MNBuilt 1981 · S/N 18504219N1393FBenham John D · Blanco, TXBuilt 1975 · S/N 18502840N13WSJohnson Chad H · Houston, TXBuilt 1979 · S/N 18503938N13WWHurd Steven C · Bangor, MEBuilt 1982 · S/N 18504378N1431EBrandt Terry R · Hood River, ORBuilt 1979 · S/N 18503840N143HJHurlburt Ward B IV · Anchorage, AKBuilt 1976 · S/N 18503032N1467FJetceo LLC · Kalispell, MTBuilt 1975 · S/N 18502845N1469FSkywagon 185 LLC · Ocala, FLBuilt 1975 · S/N 18502847N1470QHillyer Joe F · Soldotna, AKBuilt 1977 · S/N 18503483
Back to AD 75-09-06