OpenAirDocs.org
AD 75-04-04

Registered aircraft · 195

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

N100RLLong Randy B · Coleman, TXBuilt 1951 · S/N 21512N10442Hilty David J · Kodiak, AKBuilt 1957 · S/N 22595N10445Hartz Mark E · Stuttgart, ARBuilt 1953 · S/N 23397N10714Tennessee Museum Of Aviation · Sevierville, TNBuilt 1951 · S/N 22748N10715Noyes Stephen S · Newburyport, MABuilt 1951 · S/N 22816N1100TSale Reported · Olympia, WASale reportedS/N 22020N112MCForgotten Heroes Foundation Inc · Chesapeake, VABuilt 1951 · S/N 21071N1172DPlaster James F · Winston Salem, NCBuilt 1953 · S/N 23220CN119PPMount Glenn W · Modesto, CAS/N 22787N119WWDavis Bob F · Helena, MTBuilt 1951 · S/N 22481N12633East Moriches Aerial Advertising Ltd · Ridge, NYBuilt 1966 · S/N 2015N12755Real Aviation Inc · Syracuse, NYS/N 21931N140RPlaster William L · Washington, NCBuilt 1951 · S/N 22834N143FCarlton John B · Lenoir, NCBuilt 1953 · S/N 23488N14418Javarey David J · Honea Path, SCS/N 22688N14441Lufker Gregory L · Queen Creek, AZBuilt 1951 · S/N 21759N14442Michael T. Hofstetter · Saint James, MOBuilt 1951 · S/N 22217N156AGAlpert Adam L · Delray Beach, FLS/N 21707N16708Lucia G Keith · Pleasant Hill, CABuilt 1967 · S/N 2016N17307Vince John Gregory · West Ossipee, NHBuilt 1951 · S/N 22041N17396Eckel Kenneth P Jr · Santa Fe, TXBuilt 1951 · S/N 22135N1825CPellar Gregory T · Bigfork, MTBuilt 1953 · S/N 23446N1827Hughes Michael R · Nashua, NHBuilt 1962 · S/N 2001N1830Blair Lynward E · Headland, ALS/N 23445N1833Brown Helicopter Inc · Pensacola, FLBuilt 1964 · S/N 2005N1835Noyes Stephen S · Newburyport, MABuilt 1965 · S/N 2007N1837Nfm Enterprises LLC · Wurtsboro, NYBuilt 1965 · S/N 2009N1955Stephens Robert Z · Missoula, MTBuilt 1955 · S/N 23004N19JFinch Lee · Lakeway, TXBuilt 1964 · S/N 22741N19LDDanper Inc · Livingston, MTBuilt 1951 · S/N 22768N201SSEagles Nest Of The Ozarks · Springfield, MOS/N 21756N208BDUrquhart Karl E · Grangeville, IDS/N 2033N212KYAerial Banners Inc · Pembroke Pines, FLBuilt 1951 · S/N 22301N219THP Hiliarde Enterprises · Salida, COBuilt 1951 · S/N 22611N22796Mahanor Michael F · Eaton, NHS/N 23471N229PALussier John A · Greene, RIBuilt 1951 · S/N 22967N22SUHeritage Flight Museum · Burlington, WABuilt 1975 · S/N 2N24WPost Mills Soaring Club · Norwich, VTBuilt 1966 · S/N 2014N269THWings Of The North Inc · Eden Prairie, MNS/N 22819N2BKPrevost Christopher D · Sonoma, CABuilt 1951 · S/N 21648N305APhiladelphia Glider Council Inc · Hilltown, PABuilt 1951 · S/N 23182N305ABL-19 Birddog LLC · Huntington, INBuilt 1951 · S/N 21290N305ADScreaming Rubber Chicken Aviation LLC · Boise, IDS/N 21783N305BDQualitair LLC Trustee · MichelstadtBuilt 1950 · S/N 22761N305BJJones Marvin B · Farmerville, LABuilt 1951 · S/N 22465N305CRSeewald Jeffrey W · Great Bend, KSBuilt 1950 · S/N 21483N305DFPrecision Delta Corp · Ruleville, MSBuilt 1950 · S/N 21163N305FUDustoff LLC · Concord, NHBuilt 1951 · S/N 21741N305JPPattison Jeffrey L · Glasgow, MTBuilt 1951 · S/N 21789N305MRRoberts Bruce D · New London, PABuilt 1965 · S/N 2011
Back to AD 75-04-04