OpenAirDocs.org
AD 75-01-07

Registered aircraft · 2,118

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:75-01-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:75-01-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.

N135TBToth Richard Day · Thurmont, MDBuilt 1969 · S/N D-8921N135VBPriori Holdings Inc · Jacksonville, FLS/N D-10263N135WWKarwowski Richard · Battle Ground, WAS/N D-8129N1362APochwatka Patryk · Treasure Island, FLBuilt 1969 · S/N D-9011N136GBHarris Vincent A · Columbus, MSBuilt 1967 · S/N D-8557N137TWDixon Daniel N · Millersville, MDBuilt 1974 · S/N D-9631N138GGardiner Alan H · Waterford, CTBuilt 1964 · S/N D-7564N138TWSulka Andrew Mark · Pittsburgh, PABuilt 1974 · S/N D-9647N1396AEsser J Randolph Trustee · Birmingham, ALBuilt 1969 · S/N D-9012N139ROlsen David A · Marinette, WIBuilt 1978 · S/N D-10083N139TATell Christopher A · Colville, WABuilt 1974 · S/N D-9652N1417BDavis Brad Michael · Whitesboro, TXBuilt 1967 · S/N D-8550N141TWHunt Bradley · Wichita Falls, TXBuilt 1974 · S/N D-9634N141WSCopper Spike Aero LLC · Douglas, WYBuilt 1965 · S/N D-7995N142HGN142hg LLC · Manhasset, NYBuilt 1969 · S/N D-9020N1437AWashington Adrian P · Palm Harbor, FLBuilt 1969 · S/N D-9013N143KPescitelli Paul · Atlanta, GABuilt 1964 · S/N D-7664N144AAllen Engineering · San Bernardino, CABuilt 1974 · S/N D-9633N144RExtrivo Inc · Lewes, DEBuilt 1967 · S/N D-8496N145JMA&K Aviation LLC · Lambertville, MIBuilt 1980 · S/N D-10334N145MTilley Steven E · Biddeford, MEBuilt 1977 · S/N D10061N147UMartin Delano R · Spring, TXS/N D-8533N148PRJaspar Dorsey E · Bakersfield, CABuilt 1967 · S/N D-8580N148UUpmeyer Matthew D · Richland, WABuilt 1967 · S/N D-8437N149BDLewellyn Jim · Bloomsburg, PABuilt 1976 · S/N D-9924N149GMetro Flyers Ltd · N Richland Hills, TXBuilt 1966 · S/N D-8100N149RBest Erectors Inc · Wilmington, DEBuilt 1978 · S/N D-10161N14CMGallagher Michael S · Los Alamitos, CABuilt 1971 · S/N D-9298N14FMDurbin Gregory M · Dallas, TXS/N D-7802N1500FGerhold Jeremy · Rosharon, TXS/N D-8552N1500VTessem Rolfe S · Great Barrington, MABuilt 1970 · S/N D-9160N150WRWhiskey Romeo LLC · Timnath, COBuilt 1969 · S/N D-8911N1512WBryant John Mark · Knoxville, TNBuilt 1972 · S/N D-9332N1520VBerka George · Wilmington, DES/N D-8159N1527WRegistered aircraftBuilt 1972 · S/N D-9335N152JPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1966 · S/N D8322N1530WMather Aviation LLC · Rancho Cordova, CABuilt 1972 · S/N D-9338N1548WCrabb Joseph M · Tempe, AZBuilt 1972 · S/N D-9344N155JWTcpb LLC · Lewes, DEBuilt 1975 · S/N D-9837N1563WArmstrong James L Trustee · Santa Barbara, CABuilt 1972 · S/N D-9370N1566LRedden Timothy Ray · Citrus Heights, CABuilt 1976 · S/N D-9862N1571WWest Elk Construction Ltd · Milliken, COBuilt 1972 · S/N D-9349N1576WPowis Michael P · Oak Grove, MOBuilt 1972 · S/N D-9350N1579LEvans Christopher A · Lynden, WABuilt 1976 · S/N D-9863N1581WBrown David C · Overland Park, KSS/N D-9352N1583WNorton William P · Lakeville, MNBuilt 1972 · S/N D-9353N1589LCain James W · Big Rapids, MIS/N D-9866N1595LClemens Jerry W · Parsons, KSBuilt 1976 · S/N D-9869N1597WSmith William J · Wichita Falls, TXBuilt 1972 · S/N D-9359N1598WCanvasback Investments LLC · Kerrville, TXBuilt 1972 · S/N D-9356
Back to AD 75-01-07