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.

N767RRRed Leasing LLC · Juneau, AKBuilt 1972 · S/N 310Q0455N76MDNovey Gabriel Antonio · Panama CityNon-citizen corporation, flight hours not reportedBuilt 1977 · S/N 402B1055N7702QRobinson Meyer · Daphne, ALBuilt 1970 · S/N 310Q0202N7704QNyerges James R · Pflugerville, TXS/N T310Q0204N77770Bredder Brett A · Brighton, COS/N 320D0058N777ZTSee David M · Shady Shores, TXBuilt 1966 · S/N 320E0033N780MBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1972 · S/N 402B-0249N7864FKeller Russell L · Runaway Bay, TXBuilt 1968 · S/N 4010207N7875EUniversity Research Foundation · Greenbelt, MDBuilt 1973 · S/N 402B0432N789BDTroy Farms Lp · Delano, CABuilt 1973 · S/N 310Q0922N7901QKentucky Airmotive Inc · Mount Sterling, KYBuilt 1969 · S/N 401B0001N7909QSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1972 · S/N 310Q0620N7912QHagan David · Overgaard, AZBuilt 1969 · S/N 401B0012N7913QBrown Kevin B · Eureka, MTBuilt 1969 · S/N 401B0013N7925QWolf River Aviation LLC · Memphis, TNS/N 401B0025N7969QBadenhope John R · Greeneville, TNS/N 401B0109N7983QLorenso Walker Institute Of Technology · Naples, FLBuilt 1971 · S/N 401B0202N7988QCerniglia Paul · Monroe Township, NJBuilt 1971 · S/N 401B0207N7989QLauritano Stephen G · Goodyear, AZBuilt 1971 · S/N 401B0208N7AEAndrew Reed Enterprises LLC · Fostoria, MIBuilt 1965 · S/N 320D0033N7DAJanak Jeffrey · Corpus Christi, TXBuilt 1967 · S/N 402-0084N7ZZFour Clowns Aviation LLC · Wilmington, DEBuilt 1968 · S/N 310P0049N800FSNorads Aerial Services LLC · Leesburg, VAS/N 401A0119N800KWVenture Air Solutions Inc · Opa Locka, FLBuilt 1976 · S/N 402B1063N807WSInter Island Freight LLC · Deerfield Beach, FLBuilt 1968 · S/N 4010300N8091QKhag Aviation Inc · Woodbridge, NJBuilt 1973 · S/N 402B0369N8125FMaglaughlin Ronald D · Udall, KSS/N 402-0231N8179QCruce Aircraft Services LLC · Clewiston, FLBuilt 1972 · S/N 310Q0635N8188QI Will Rise LLC · Chattanooga, TNBuilt 1972 · S/N 310Q0638N81ADMr Dent Inc · Manheim, PAS/N 401A0023N829EDiaz Maria · Kansas City, MOS/N 401A0014N82TAJanes Paul A · Ontario, ORBuilt 1968 · S/N 402-0156N8422FTownsend David · Piedmont, SCS/N 402-0270N87CGPro Aire Cargo & Consulting Co Inc · Oshkosh, WIBuilt 1975 · S/N 402B0883N881PJJohnson Patrick Allen · Olive Branch, MSBuilt 1973 · S/N 310Q0754N8FBRichland Aviation Inc · Sidney, MTBuilt 1978 · S/N 402B1372N9063MThompson Anthony · Miami, FLBuilt 1971 · S/N 402B-0105N909AAKings Wings Inc · Jupiter, FLBuilt 1968 · S/N 401-0227N951LEChi Walter D · Aspen, COS/N 320F-0029N98649Dodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 402B1030N98697Gimli Son LLC · Fort Lauderdale, FLS/N 402B1053N9873FAirswiss Inc · Wilmington, DEBuilt 1968 · S/N 402-0303N989AAMouat Brian · Trent Woods, NCS/N 401A-0042N999BSSale Reported · Moss Beach, CASale reported, pending cancellationBuilt 1968 · S/N 320F-0041N9RVPotter Steven R · Grapevine, TXS/N 310Q0234
Back to AD 70-03-04 R1