OpenAirDocs.org
AD 70-03-05

Registered aircraft · 3,666

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-05')
    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-05')
  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.

N1000THaughton Douglas L · Gig Harbor, WABuilt 1957 · S/N D-4980N100FBHoffman Swen · Sedalia, COBuilt 1963 · S/N D-7158N100TBAlexander Aviation LLC · Brighton, COBuilt 1963 · S/N CD-637N101BBPolson Taylor M · Killeen, TXBuilt 1959 · S/N D-6076N101HTWilder Bart M · Maryville, TNBuilt 1958 · S/N D-5722N101JMSale Reported · Clay Center, KSSale reportedBuilt 1967 · S/N D-8459N102RBLeuszler Robert L · Lenexa, KSBuilt 1968 · S/N D-8865N1037BSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1957 · S/N D-5311N1039A39a LLC · Sioux Falls, SDS/N D-9009N103WWWilkin Richard G · Monticello, ILBuilt 1961 · S/N CD439N105FADebbie Air LLC · Perkasie, PABuilt 1965 · S/N CD-853N105XSaalwaechter John J · Lebanon, INBuilt 1960 · S/N D-6436N1069FRobinson Andrew · Wernersville, PABuilt 1968 · S/N CE230N106NChenevert Eric M · Clarence, NYBuilt 1962 · S/N D7035N106VKenyon Joseph S · Fort Collins, COBuilt 1959 · S/N D-6009N1077B85 Alpha Inc · Wilmington, DEBuilt 1957 · S/N D-4931N107JSSayers James B · Edison, OHBuilt 1975 · S/N CJ-88N107VWHenning Nancy E · Hardinsburg, KYBuilt 1960 · S/N CD-71N108GBLooney Jordan · Trumann, ARBuilt 1960 · S/N D-6422N109QShariff Diane · Cameron Park, CABuilt 1966 · S/N D-8126N109VKeeling Rodney E · Pearce, AZBuilt 1960 · S/N CD-160N10UDMacasek John · Caledonia, MSBuilt 1968 · S/N D-8676N10ULSurber Medical Enterprises LLC · Waverly Hall, GABuilt 1964 · S/N D-7430N10WRWilson Keith · Saint Joseph, MIBuilt 1964 · S/N D-7689N110CCIntermountain Aero Inc · Salt Lake City, UTBuilt 1966 · S/N D-8339N1110CGriffith Danny E · Little Rock, ARS/N D-5117N11114Daly Arthur P · El Paso, TXBuilt 1968 · S/N D-8901N1111ZHamburger Ronald O · Terrebonne, ORBuilt 1960 · S/N CD-276N111CVN2xt LLC · Austin, TXS/N D-7718N111ECGs Wings Inc · Pawnee, ILBuilt 1967 · S/N D-8385N111GSWiebener John W · Alva, OKBuilt 1968 · S/N D-8780N111KFrizzell Kim F · Lakeville, MNBuilt 1961 · S/N D6786N111MSMid America Sprayers Inc · Johnson, KSBuilt 1966 · S/N D-8249N111TWScott Hersmon Builder Inc · Ada, MIBuilt 1967 · S/N D-8641N111YBVanicek Nicholas Andrew · Whispering Pines, NCBuilt 1962 · S/N D-6962N1124AWillhope Aviation LLC · Mckinney, TXBuilt 1969 · S/N E-157N112GBN112gb LLC · Oldsmar, FLBuilt 1964 · S/N CD796N112SPowell Paul L · Rancho Cucamonga, CABuilt 1964 · S/N D-7466N112XAir Corriente LLC · Columbia, TNBuilt 1966 · S/N D-8121N1130MTelbo LLC · Vonore, TNBuilt 1965 · S/N D-8023N113DPelstring Robert Michael · Santa Cruz, CABuilt 1966 · S/N CE-2N113JLHare Richard C · Northville, MIBuilt 1966 · S/N D-8167N113VSaravis Darren S · Long Beach, CABuilt 1965 · S/N D-7958N113XClement James G · Cresson, TXBuilt 1966 · S/N D-8112N1148TCorlett Samuel E · Fort Worth, TXBuilt 1958 · S/N D-5453N1151XSummers Jayson V · Poway, CABuilt 1961 · S/N D-6705N115MRRussell Keith M · Ivoryton, CTBuilt 1960 · S/N D-6394N1183ABronson Nw Inc · Redmond, ORBuilt 1969 · S/N D-9006N118NSagouspe Consulting Services LLC · Hayden, COBuilt 1960 · S/N D-6427N118VSmith Gregg W · Lake Jackson, TXBuilt 1966 · S/N D-8096
Back to AD 70-03-05