AD 76-03-01

Registered aircraft · 87

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:76-03-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:76-03-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.

N52TTMinuteman Aviation Inc · Missoula, MTBuilt 1979 · S/N 31T-7920057N53MCGulf Air Aviation Inc · Wilmington, DEBuilt 1978 · S/N 31T-7820025N53TAIndiana Paging Network Inc · La Porte, INBuilt 1978 · S/N 31T-7820083N545RKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1977 · S/N 31T-7720064N55RPneuma Aviation LLC · New Orleans, LABuilt 1976 · S/N 31T-7620055N59EHSale Reported · Dawsonville, GASale reported, pending cancellationBuilt 1978 · S/N 31T7820014N5DValiair Ltd Co Trustee · Casper, WYBuilt 1978 · S/N 31T-7820080N606DWElkhorn Valley Trucks II LLC · Fremont, NEBuilt 1981 · S/N 31T-8120038N6107AR & R Aviation Support LLC · Atlanta, GABuilt 1978 · S/N 31T-7820087N6175ATiffin Aire Inc · Tiffin, OHBuilt 1979 · S/N 31T-7920011N620DBAlco Plane Co LLC · Memphis, TNBuilt 1979 · S/N 31T-7920055N65BATts Leasing Inc · Kansas City, KSBuilt 1980 · S/N 31T-8020071N67DWDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 31T-7620041N68BJCrownair LLC · Mansfield, PABuilt 1979 · S/N 31T7920029N723JPTiffin Aire Inc · Tiffin, OHBuilt 1978 · S/N 31T-7920009N730PTTwin Otter International Ltd · Las Vegas, NVBuilt 1977 · S/N 31T-7720008N770MGPlan Bee LLC · Washington, DCS/N 31T7520029N77NLNew South Inc · Charleston, SCBuilt 1977 · S/N 31T-7720038N781CKSnowy Owl Aviation LLC · Charlottesville, VABuilt 1978 · S/N 31T-7820056N7FLCentral Virginia Aviation Inc · Petersburg, VABuilt 1978 · S/N 31T-7820082N801HLKp Equipment Investments LLC · Cottonwood, AZBuilt 1979 · S/N 31T-8020016N80MALsc Construction Inc · Perris, CAS/N 31T7720043N83CACheyenne 2 LLC · Colonial Heights, VABuilt 1980 · S/N 31T-8020072N843DBDoan Creek LLC · Walla Walla, WABuilt 1978 · S/N 31T-7820090N89JASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 31T7920030N90FSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 31T-8020011N910AGCreative Marketing Associates Inc · Saint Petersburg, FLBuilt 1984 · S/N 31T-8004041N910HGTiffin Aire Inc · Tiffin, OHS/N 31T-7400009N910JPRegistered aircraftBuilt 1977 · S/N 31T-7820004N913NCDeweese Michel J · Rockvale, TNBuilt 1981 · S/N 31T-8120044N937TTPlanemarketing LLC · Vero Beach, FLFirst renewal noticeBuilt 1977 · S/N 31T-7720037N950CTJack Of Queens LLC · Afton, OKBuilt 1977 · S/N 31T-7720069N970PSKrech Greg Trustee · Huron, SDBuilt 1979 · S/N 31T-8020023N982KAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 31T-7820011N990LRDavis Aviation Inc · Brandon, MSBuilt 1978 · S/N 31T7820060N998LMArmstrong Airlines Inc · Dover, DEBuilt 1980 · S/N 31T-8120006N99VATwin Otter International Ltd · Las Vegas, NVBuilt 1976 · S/N 31T-7720007
Back to AD 76-03-01