OpenAirDocs.org
AD 70-03-04 R1

Registered aircraft · 245

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:70-03-04-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:70-03-04-R1')
  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.

N1008AAerial Surveys International LLC · Watkins, COBuilt 1967 · S/N 402-0097N101MEIbs America Corp · Wilmington, DEBuilt 1969 · S/N 401A0130N103ECAerial Surveys International LLC · Watkins, COBuilt 1967 · S/N 401-0135N105KAGillespie Todd · Trenton, SCS/N 401-0238N10AAPeterson Andrew · Louisville, KYBuilt 1966 · S/N 320E0046N111SDMarc Inc · Bolton, MSBuilt 1969 · S/N 310P0200N117WWNowak Jerome S · Elmhurst, ILS/N 320D0096N119PARicciardi Brian P · Hyannis, MAS/N 402B0610N12QHawkes F Bryant · Lake Dallas, TXBuilt 1966 · S/N 401-0014N13BPN13bp LLC · Walla Walla, WAS/N 320D0123N145TTVenture Air Solutions Inc · Dallas, GABuilt 1977 · S/N 402B1333N15DSAll Attitude Aviation Inc · Edgewater, FLBuilt 1965 · S/N 320D0079N167WAGrid Aero Inc · San Leandro, CABuilt 1976 · S/N 402B1044N175KBTvpx Ars Inc Trustee · North Salt Lake, UTS/N 401B0206N1915WPasha Mohammad A · Muscatine, IABuilt 1971 · S/N 310Q0429N20EZRegistration Pending · Bigfork, MTRegistration pendingBuilt 1969 · S/N 310P0078N21MTTarrant County College · Fort Worth, TXBuilt 1967 · S/N 320F-0017N220XPOleary Patrick G · Lake Tapps, WAS/N T310Q01020N222LTwo Motor Odor LLC · Paris, TXS/N 320E-0053N222MDElx Aviation LLC · Hartford, MIBuilt 1974 · S/N 310Q1013N236STOutdoor Metal Products LLC · Leighton, ALBuilt 1968 · S/N 401A0020N241AREllison Aviation LLC · Conroe, TXBuilt 1967 · S/N 320F-0012N27KCLaperle Brian · Colebrook, NHBuilt 1974 · S/N 310Q1134N28409Gilmore Sherry · Sallisaw, OKS/N 310Q0666N28849Roonie Inc · Wilmington, DES/N 310Q0036N289VVBooth Emmett W · Waitsburg, WAS/N 320E-0110N2JJAerial Surveys International LLC · Watkins, COBuilt 1968 · S/N 401-0235N300FDGondola Investments LLC · Miami, FLS/N 402B1359N302MCB & G Ventures LLC · Kalispell, MTBuilt 1973 · S/N 310Q0909N303DCRegistered aircraftBuilt 1973 · S/N 402B-0303N308CFBaba Kenneth D · Sierra Vista, AZBuilt 1973 · S/N 310Q0804N30ETZaldivar Carlos · Miami, FLBuilt 1971 · S/N 310Q0266N310BLAlsager Joshua D · Kindred, NDS/N 310Q0069N310CESwainston Ian · Las Vegas, NVBuilt 1974 · S/N 310Q1063N310DChispa Air LLC · Cedar Park, TXBuilt 1969 · S/N 310Q0002N310DHFavero Robert B · Weed, CABuilt 1974 · S/N 310Q1086N310EWAerial Imaging Inc · South Bend, INBuilt 1973 · S/N 310Q0935N310FJSimmonds Don M · Sandpoint, IDS/N 310Q0542N310GCCook Kevin M · Missouri City, TXBuilt 1973 · S/N 310Q0838N310JPBrock Kyle · Riverdale, CABuilt 1972 · S/N 310Q0648N310TQRegistration Inc · Kalispell, MTS/N 310Q0818N310TTTriple J Flying Inc · Wilmington, DEBuilt 1973 · S/N 310Q0810N3131KAmazon Aero Corp · Wilmington, DEBuilt 1972 · S/N 402B0248N317TRRcs Aeronautical Inc · San Antonio, TXBuilt 1973 · S/N 310Q0787N320ARAir Sal Leasing Inc · Fort Myers, FLS/N 320E-0079N320FWMurrell James F · Douglas, AZBuilt 1967 · S/N 320F-0018N320JKTru-Point Tactical LLC · Columbia, MSBuilt 1966 · S/N 320E0048N320MSConsulat Inc · Cheyenne, WYBuilt 1966 · S/N 320E-0065N320PCAom Aircraft LLC · Wilmington, DES/N 402B0621N320SKDevries James E · Bejou, MNBuilt 1967 · S/N 320E-0077
Back to AD 70-03-04 R1