OpenAirDocs.org
AD 74-26-07

Registered aircraft · 3,504

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

N1000PJames Bond Aviation LLC · Belgrade, MNBuilt 1963 · S/N 28-1000N1009XEnders Richard A · San Bernardino, CABuilt 1975 · S/N 28-7505194N100HRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 28-4509N100JEResearch Consultant Solutions LLC · Miami, FLBuilt 1969 · S/N 28-5489N1034XBlasa Randy · Bowling Green, FLS/N 28-7505198N103TTAero Dynamics Flying Club Inc · Mulino, ORBuilt 1974 · S/N 28-7505092N1041XGyllensten Scott · Guilford, CTBuilt 1975 · S/N 28-7505199N1057XWeisenberger Thomas · Norwalk, OHBuilt 1975 · S/N 28-7505202N1060TWindy Hill Farm LLC · Cochranville, PABuilt 1972 · S/N 28-7205104N1067XArchey Richard L · Georgetown, KYBuilt 1975 · S/N 28-7505204N1072XDemaagd Ross E · Middleville, MIBuilt 1975 · S/N 28-7505206N1082XWhitmer Ronald N · Ellsworth, KSBuilt 1975 · S/N 28-7505207N109RBClark William R · Anchorage, AKBuilt 1965 · S/N 282612N1102XMarak Enterprises LLC · Galena, MOBuilt 1975 · S/N 28-7505210N1109XBruno Michael J · Pittsburg, CABuilt 1975 · S/N 28-7505211N110TNMaloney Casey · Placerville, CABuilt 1972 · S/N 28-7305054N1118ZMoorhouse Mark A · Santa Fe, TNBuilt 1963 · S/N 28-1118N111NPBlackfoot Aviation LLC · Bozeman, MTS/N 28-3046N1144XFly Texas Sky LLC · Arlington, TXBuilt 1975 · S/N 28-7505215N114CFAw Chartering LLC · Franklin, TNBuilt 1974 · S/N 28-7505080N1159XBarrett Tyler J · Cullman, ALS/N 28-7505217N1168XJz Air LLC · Brooklyn, NYBuilt 1975 · S/N 28-7505219N1178XN1178x LLC · Dover, DEBuilt 1975 · S/N 28-7505220N1184XLairson Samuel E III · Ocean City, NJBuilt 1975 · S/N 28-7505221N1185XWilliamson Flying Club Inc · Williamson, NYBuilt 1975 · S/N 28-7505222N1188TAbrams Jeffrey Scott · Phoenix, AZBuilt 1964 · S/N 28-1883N1198XDiscover Aviation Center LLC · Elyria, OHBuilt 1975 · S/N 28-7505223N11GNHaley James M Trustee · Edmond, OKBuilt 1973 · S/N 28-7305330N11HAVintage Aero Inc · Brandon, FLBuilt 1973 · S/N 28-7305338N11KAlbers Edward C · Burlington Flats, NYBuilt 1968 · S/N 28-4725N11NTSabb Anthony · Wetumpka, ALBuilt 1972 · S/N 28-7205193N1206TCps 1 LLC · Pelham, ALBuilt 1972 · S/N 28-7205266N1214TPost 8 Flight Opps Inc · Topeka, KSBuilt 1972 · S/N 28-7205268N1226TLinde Glenn F Jr · Juneau, WIBuilt 1972 · S/N 28-7205269N122HSMarbury Sherri E · Jackson, TNBuilt 1965 · S/N 28-2377N1235SBarney Erick L · Jacksonville, ORBuilt 1967 · S/N 28-4306N123GEFlying Four Inc · Saint Petersburg, FLBuilt 1971 · S/N 28-7205062N123SWBelschner Custom Meats · Amherst, NEBuilt 1972 · S/N 28-7305105N1242TDoblmaier Thomas J · North Wales, PABuilt 1972 · S/N 28-7205272N124JCDestination Aviation LLC · Destin, FLBuilt 1965 · S/N 28-2340N1261TObrien Timothy D · Alplaus, NYBuilt 1972 · S/N 28-7205273N1270TTubman Wilbur C · Grand Rapids, MIBuilt 1972 · S/N 28-7205274N127MDCosbie Lee R · Tuscumbia, ALBuilt 1963 · S/N 28-1503N1284NAbnc Air LLC · Wellington, FLS/N 28-7405076N1286THeffelfinger Paul D · Seven Valleys, PABuilt 1972 · S/N 28-7205277N1295TLutz Brian · Carmel, INBuilt 1972 · S/N 28-7205278N1318TAire-Drifter LLC · Staten Island, NYS/N 28-7205280N1326TNelson Raul · Annapolis, MDBuilt 1972 · S/N 28-7205286N1332TSchwartz Matthew M · Royal Oak, MIBuilt 1972 · S/N 28-7205283N1346TNortham Thaddeus R · Mckinney, TXS/N 28-7205284
Back to AD 74-26-07