OpenAirDocs.org
AD 68-12-04

Registered aircraft · 536

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:68-12-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:68-12-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.

N1094TGlover Anthony R · Louisville, KYBuilt 1969 · S/N 28R-31116N117VRAtmospheric Vehicle & Spacecraft Flght Exploration · Rch Palos Vrd, CABuilt 1968 · S/N 28R-30443N11FLBell Christopher K · Ashley, OHBuilt 1968 · S/N 28R-30444N1222TPraniewicz Charles P · New Kensington, PABuilt 1968 · S/N 28R-30582N12354Spencer Christopher · Voorheesville, NYBuilt 1968 · S/N 28R-30607N1284WBethel Don G · Bossier City, LABuilt 1967 · S/N 28R-30304N128GRJaques Stanley S · Cassville, MOBuilt 1968 · S/N 28R-30806N134JSSparling Albert E · Hubbard Lake, MIBuilt 1968 · S/N 28R-30517N1511Plane Fun LLC · Warrensburg, MOS/N 28R-31114N16HLPlane Fun Inc Tr Trustee · Snellville, GABuilt 1968 · S/N 28R-30675N171JBAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1968 · S/N 28R-30756N180CVN Registration Service LLC Trustee · Sanford, NCBuilt 1968 · S/N 28R30693N19SERegistered aircraftBuilt 1968 · S/N 28R-30525N20LGYerena Mario Cesar Gutierrez · Bethel Island, CABuilt 1968 · S/N 28R-30491N2111SSchwab Jollina Michelle · Arlington, TXBuilt 1970 · S/N 28R-31048N2112TMarsh James M · Polkton, NCBuilt 1971 · S/N 28R-7130002N21ASBoa Properties LLC · Valdosta, GABuilt 1968 · S/N 28R-30862N2321THobson Joseph C · Beverly Hills, FLBuilt 1971 · S/N 28R-7130009N2330TSteele Jackie L · London, KYS/N 28R-7130010N23653Gales Charles R · Cleverdale, NYBuilt 1968 · S/N 28R-30691N246ADBialas Robert E II · Fort Worth, TXBuilt 1968 · S/N 28R-30423N251DBSnoopys Air Service LLC · Wappingers Falls, NYBuilt 1968 · S/N 28R-30426N26893Goodman Harold Wayne · Clovis, CAS/N 28R-30679N28NCHurley Thomas W · Plymouth, MABuilt 1968 · S/N 28R-30357N292RMJunk Troy A · Wshngtn Ct Hs, OHBuilt 1968 · S/N 28R-30955N29SDRegistered aircraftBuilt 1968 · S/N 28R-30583N2UNSuriel Darleny G · New York, NYBuilt 1969 · S/N 28R-31080N3109PSoft Works Systems Inc · Jamesville, NYBuilt 1969 · S/N 28R-31109N312CADunn Jonathan · Murfreesboro, TNBuilt 1968 · S/N 28R-30590N3130RN738yc LLC · Fresno, CABuilt 1969 · S/N 28R-31115N3135RSerna Alvaro V · San Antonio, TXBuilt 1969 · S/N 28R-31117N3173RRona LLC · Phoenix, AZBuilt 1969 · S/N 28R-31121N3174RSeifert Richard W · Big Bear City, CAS/N 28R-31122N3177RLaviano Kenneth J · Westwood, NJBuilt 1969 · S/N 28R-31125N3200RTexeira David A · Venice, FLBuilt 1969 · S/N 28R-31126N3207RLingerfelt Joseph A · Woodburn, ORBuilt 1969 · S/N 28R-31129N3219RSotelo Aviation LLC · Naples, FLBuilt 1969 · S/N 28R-31132N3225RHansen Duane D · Rockford, ILBuilt 1969 · S/N 28R-31134N322CARoyal Majesty Aviation LLC · Atlanta, GAS/N 28R-7130013N322HCClover Park Technical College · Tacoma, WABuilt 1969 · S/N 28R-31096N3231RAll2fly LLC · Atlanta, GABuilt 1969 · S/N 28R-31000N3241RJohnson Edward Wayne · Bloxom, VABuilt 1969 · S/N 28R-31023N3245RA & W Cattle Co · Flippin, ARBuilt 1969 · S/N 28R-31019N3247RArrowood Bradley W · Winston Salem, NCBuilt 1970 · S/N 28R-31111N3274RBurton Re Holdings LLC · Mustang, OKBuilt 1970 · S/N 28R-31258N3280RAmson Technology Lc · Des Moines, IABuilt 1969 · S/N 28R-31260N3284REsser Jill · Mason, MIBuilt 1970 · S/N 28R-31261N3287RWright Maurice · Las Vegas, NVBuilt 1970 · S/N 28R-31262N3293RBrook Jacob C · Broken Arrow, OKBuilt 1969 · S/N 28R-31264N3294RMurray Dennis P · Malta, NYBuilt 1969 · S/N 28R-31265
Back to AD 68-12-04