OpenAirDocs.org
AD 70-15-03

Registered aircraft · 579

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-15-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:70-15-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.

N1000JEagle Mountain Aviation Inc · Owasso, OKBuilt 1966 · S/N M-1000N101FDLakala Aviation Inc · Vicksburg, MIS/N MB-417N10NRRobbins Warren N · Chandler, AZBuilt 1968 · S/N M-1165N113FCDistributed Motion LLC · Sandpoint, IDBuilt 1969 · S/N M-1229N1167MN1167m LLC · Saint Peters, MOBuilt 1967 · S/N M-1082N117DMApplied Professional Solutions Llp · Jacksonville, FLBuilt 1968 · S/N MB-381N1402LRaskin Michael · Henderson, NVBuilt 1965 · S/N M-791N1406LBrainerd Philip S · Lake Placid, FLBuilt 1965 · S/N M-795N1409LMusketeer Flying Club LLC · Plano, TXBuilt 1965 · S/N M-798N1414LBrown Joseph T · Saginaw, MIBuilt 1965 · S/N M-806N1417LBright David P · Wachapreague, VABuilt 1965 · S/N M-809N1423LMedi Carriers Of Wisconsin Inc · Greenville, WIBuilt 1965 · S/N M-817N1426LMartin Michael D · Decatur, TXBuilt 1965 · S/N M-820N1431LJke Family Fun Entertainment Inc · Searcy, ARBuilt 1965 · S/N M-827N1432LStrydom Cornelis F · Liberal, KSBuilt 1965 · S/N M-826N1434LPost Greg G · Mapleton, KSBuilt 1965 · S/N M-829N1436LDelis Costa Z · Heyburn, IDS/N M-831N1441LSayre Jeremy Q · Livonia, MOBuilt 1965 · S/N M-835N1444LClifton Gary R · Fowler, INBuilt 1965 · S/N M-838N1450LByrd Aviation LLC · Marshfield, MOBuilt 1965 · S/N M-845N1462LSchneider Matthew B · Laughlin Afb, TXS/N M-857N1463LSpears Martin J · Havelock, NCBuilt 1965 · S/N M-858N1465LLoehr Fred A III · Rio Rancho, NMBuilt 1965 · S/N M-862N1466LSteel Randy W · Madras, ORS/N M-880N1468LCh Repairs LLC · Statesboro, GAS/N M-864N1470LAl-Rubaiie Haider A · Fort Worth, TXBuilt 1965 · S/N M-866N1471LLee Michael Jason · Berryville, VABuilt 1965 · S/N M-867N1475L2328 Charlie Victor LLC · Richmond, KYBuilt 1965 · S/N M-871N1477LCooper Jonathan Thomas · Tempe, AZBuilt 1965 · S/N M-874N1478LBaline Lonny R · Harleysville, PABuilt 1965 · S/N M-873N1481LOsceola Aviation Services Inc · Lake City, FLBuilt 1965 · S/N M-879N1487LSheets Mark W · Chugiak, AKBuilt 1965 · S/N M-887N1492LSalzer Mychael D · Coulterville, ILS/N M-892N1498LWheaton Blake L · Atlanta, GABuilt 1966 · S/N M-898N1499LHicks Philip R Jr · Knoxville, TNBuilt 1966 · S/N M-899N164DAAv Beech Holding LLC · Mandeville, LABuilt 1966 · S/N MA-101N16727Armstrong Bernard A · Cerrillos, NMBuilt 1969 · S/N MB-444N16BDLambert Thomas E · Roland, IABuilt 1969 · S/N MB-456N16THMosquera Daniel · Miami, FLBuilt 1966 · S/N M-994N17BWLoeffler Helmut Guenter · Prattsburgh, NYBuilt 1968 · S/N MB-344N1800PRegistered aircraftBuilt 1968 · S/N MA-326N18BWFarris Fred · Gladstone, MOBuilt 1969 · S/N MB-431N1963FSarna David E · Manawa, WIBuilt 1963 · S/N M-541N200AGDively Daniel R · Friedens, PABuilt 1967 · S/N MA-285N2063XKimbrough Paul E Jr · Saint Cloud, FLS/N M781N2127UFox Robert H · Wyandotte, MIBuilt 1969 · S/N MB-447N215RCGulf Coast Aviation LLC · New Orleans, LAS/N MA-89N222BBMatz Jeremy L · Toston, MTS/N M-250N2300JRadosevich Michael K · Albuquerque, NMBuilt 1963 · S/N M-246N2300LAv8n Idaho LLC · Greenleaf, IDBuilt 1962 · S/N M-112
Back to AD 70-15-03