AD 75-08-03

Registered aircraft · 10,858

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

N1479XDunn Michael J · Nashua, NHBuilt 1975 · S/N 28-7515411N1481XBadgerland Aero Club Inc · Fitchburg, WIBuilt 1975 · S/N 28R-7535289N1484TPolasik Julia Suzanne · Victor, IDBuilt 1972 · S/N 28-7225531N1484XAlpha-One Air Service LLC · Concord, NCBuilt 1975 · S/N 28-7505233N1485XBond Bryce W · Chandler, AZBuilt 1975 · S/N 28R-7535290N1486TSpivey Darwyn D · Guntersville, ALBuilt 1972 · S/N 28-7225533N1486XMidwest Investment Corp · Griffith, INS/N 28R-7535291N1487TFalcon Flying Club LLC · Fayetteville, GABuilt 1972 · S/N 28-7205307N1491TGreat Lakes Air Ventures LLC · Mason, MIBuilt 1972 · S/N 28-7205308N1492TLargo Logistics LLC · Port Orange, FLBuilt 1972 · S/N 28R-7235305N1498TMurwin Keith T · Douglasville, GABuilt 1972 · S/N 28R-7235307N1499HMeloney Leeyoung Chase · Peachtree City, GAS/N 28-7725146N149DCDale Gared W · Hugo, OKS/N 28-2643N149JLKenyon Terry J · Henderson, ARBuilt 1975 · S/N 28R-7535109N14DP5b Aviation LLC · Duncan, OKBuilt 1970 · S/N 28-5738N14LNSchultz Tim J · Mount Juliet, TNBuilt 1971 · S/N 28-7225043N14NRPiper Capital Investments LLC · Denton, TXBuilt 1965 · S/N 28-20614N15002Registered aircraftBuilt 1972 · S/N 28-7205315N15003Flying Untethered LLC · Saranac Lake, NYBuilt 1972 · S/N 28-7225548N15005Oliver Everett G · No Mankato, MNBuilt 1972 · S/N 28-7205316N15006Corio Salvatore J Jr · Warwick, RIBuilt 1972 · S/N 28R-7235315N15007Marshall County Flying Club Inc · Lacon, ILBuilt 1972 · S/N 28R-7235316N15010Van Buskirk James R · Tuttle, OKS/N 28-7225550N15013Krantz Gwendolyn A · Advance, NCBuilt 1972 · S/N 28R-7235318N1501XBowser William K · Ball Ground, GABuilt 1975 · S/N 28-7505235N15021Brandywine Flight School · West Chester, PABuilt 1972 · S/N 28R-7235319N15022Registration Pending · Riverside, CARegistration pendingBuilt 1972 · S/N 28R-7335001N15027Mallue Jeff · Springboro, OHBuilt 1972 · S/N 28R-7235320N15032Ross Adam D · Bixby, OKBuilt 1972 · S/N 28-7225555N15033Fca Flight Training LLC · Washington C H, OHBuilt 1972 · S/N 28-7225556N15034Pathfinder Aviation Services LLC · St Johns, FLBuilt 1972 · S/N 28-7225557N15037Ace Aircraft Leasing Inc · Nazareth, PABuilt 1972 · S/N 28-7225560N1503XGasoline Valley LLC · Clyde, MIS/N 28-7525324N15044Summit Flight Academy LLC · Peculiar, MOBuilt 1972 · S/N 28-7225564N15046Neboschick Ashley B · North Charleston, SCBuilt 1972 · S/N 28-7325002N1504JRuminski Pamela S · Salesville, OHBuilt 1967 · S/N 28-23897N1504TChavez David L · Cedar Park, TXBuilt 1972 · S/N 28-7225500N1504XVerge Aeronautics LLC · Charlotte, NCBuilt 1975 · S/N 28R-7535301N15050Houston William W · Baltimore, MDBuilt 1972 · S/N 28-7225569N15051Phoenix Proaviation LLC · Jacksonville, FLS/N 28-7225570N15057Bad Dog Aviation · Meridianville, ALBuilt 1972 · S/N 28-7225572N1505XFarrell Donald A · Owasso, OKBuilt 1975 · S/N 28R-7535302N15066Cherokee Aviation Group LLC · Alpharetta, GABuilt 1972 · S/N 28-7225577N1506HRegistration Pending · Cape Canaveral, FLRegistration pendingS/N 28-7725147N1506TWaldrep Zoey V · Tampa, FLS/N 28-7225538N15079Rea Robert III · Bumpass, VABuilt 1972 · S/N 28-7225585N1507TAero Care Inc · Orange, MABuilt 1972 · S/N 28-7205310N1508JLiwag Reynaldo T Jr · Niagara Falls, NYBuilt 1967 · S/N 28-23901N1508TWalker Jereme · Durham, NCBuilt 1972 · S/N 28R-7235308N150PKInternational Air Services Inc Trustee · Carson City, NVS/N 287725108
Back to AD 75-08-03