AD 75-09-08

Registered aircraft · 3,035

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-08')
    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-08')
  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.

N188DHDunworth Jack R · Rutledge, GABuilt 1968 · S/N 680119N188GHAer Lightfoot LLC · Alpena, MIBuilt 1964 · S/N 525N18JKTalley Warbirds Inc · Longview, TXBuilt 1969 · S/N 690020N1900YMarrero Francisco J · Lake Charles, LABuilt 1964 · S/N 2684N1902YFlowers John H · Laurel, MSBuilt 1964 · S/N 287N1909YDuncan Lori Ann · New Tazewell, TNBuilt 1964 · S/N 204N1910YPeabody Riley A · Minnetonka, MNBuilt 1964 · S/N 205N1912YFrokjer Dean C · Saint Croix Falls, WIBuilt 1964 · S/N 207N1913YSchmitt William Joseph · Santa Cruz, CABuilt 1964 · S/N 208N1915YJordan S Connor · Elizabeth City, NCBuilt 1964 · S/N 210N1916YLarsen Adam P · Gresham, ORBuilt 1964 · S/N 211N1917YMock Joseph R · Huntsville, TXBuilt 1964 · S/N 212N1919YSu Ryan · Saint Augustine, FLBuilt 1964 · S/N 214N191ABRegistration Pending · Newport, ORRegistration pendingBuilt 1963 · S/N 2471N191DJScallion Leon Ivy · Pine Bluff, ARBuilt 1965 · S/N 3206N191HCTrinair Aviation LLC · Hampshire, ILBuilt 1965 · S/N 2992N191PALa Mooneytte LLC · Seabrook, SCBuilt 1964 · S/N 248N1920CVanjara Gufran U · San Ramon, CABuilt 1964 · S/N 2686N1922YDurso Joseph M Jr · Mesa, AZBuilt 1964 · S/N 217N1923YHyde Joe G · San Angelo, TXBuilt 1964 · S/N 218N1924YHull Thomas · Midland, TXS/N 219N1925YMapes Peter B · Oscoda, MIBuilt 1964 · S/N 220N1926YRoss Dustin · Georgetown, TXBuilt 1964 · S/N 221N1928YMaddex William E · Battle Ground, WAS/N 235N1932YDriver L Spence · Bay City, WIBuilt 1964 · S/N 239N1934YMack Anita · Scott Afb, ILBuilt 1964 · S/N 241N1935YHodges William L Jr · Spotsylvania, VABuilt 1964 · S/N 289N1937YTirado Josue · Pembroke Pines, FLBuilt 1964 · S/N 244N1939YMcconnell Kristopher P · Nampa, IDFirst renewal noticeBuilt 1964 · S/N 246N193DRLinden Elizabeth M · Mc Farland, WIS/N 193N1940YMiller Rollie R · Dillon, MTBuilt 1964 · S/N 247N19411Taylor Fred H · Plano, TXFirst renewal noticeBuilt 1969 · S/N 690085N1944YHolcombe Thomas Hg · Moss, TNBuilt 1964 · S/N 251N1946YTrimmer Benjamin M · Tomball, TXBuilt 1964 · S/N 253N1948YGregory Michael Rybarczyk · West Chester, OHBuilt 1964 · S/N 255N1949YHawkins Robert A · Lake Butler, FLBuilt 1964 · S/N 256N1952YVess Derek Wayne · Kempner, TXBuilt 1964 · S/N 259N1953YDavid Michael B · Miami Beach, FLBuilt 1964 · S/N 260N1954YSasse David L · Rio Rancho, NMS/N 2691N1955YBeckworth Willis S · Gonzales, LABuilt 1964 · S/N 262N1957YGuedon Aviation LLC · Natchez, MSBuilt 1964 · S/N 222N1959YJam Aviation LLC · Wallace, MIBuilt 1964 · S/N 224N1960YWhite Duwayne F · Hermiston, ORBuilt 1964 · S/N 225N1961YWarnock Tony J · Mobile, ALS/N 226N1962YRuther Jimmie M · Vacaville, CABuilt 1964 · S/N 227N1963YLane Cary · Sapello, NMBuilt 1964 · S/N 228N1964YPerry Shawn M · Springfield, OHS/N 229N1965YSvoboda Patrick J · Bucyrus, KSBuilt 1964 · S/N 230N1966YWeyhrich Dorothy · Windsor, COBuilt 1964 · S/N 231N1967FLeander Henry Anske IV · San Antonio, TXBuilt 1967 · S/N 670456
Back to AD 75-09-08