OpenAirDocs.org
AD 73-20-07 R2

Registered aircraft · 1,348

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

N24590Nice Flying LLC · Williamsburg, VABuilt 1972 · S/N MB-546N24592Kovac Brett D · Colorado Springs, COS/N M-1547N24595Baisch Troy W · Oceanside, CABuilt 1972 · S/N MB-542N24597Smoketown Flight Center LLC · Smoketown, PABuilt 1972 · S/N MB-549N24598Johnson Jay W · Wichita, KSS/N M-1419N24599Petrie Jerry W · Ozark, ALBuilt 1972 · S/N M-1409N245CERichards William · West Jefferson, OHBuilt 1972 · S/N M-1412N245MJMaensivu Maverick Juha · Apopka, FLS/N MB 814N24600League Zachary E · Carter, OKBuilt 1972 · S/N MB-543N24602Mcclain Alex · Camdenton, MOBuilt 1972 · S/N MB-551N24605Deakins Glenn F · Ringgold, GAS/N MB-553N24608Haney Jeffrey B · Carrollton, GABuilt 1972 · S/N MC-142N24615Mclean Aviation LLC · Phoenix, AZS/N M-1406N24618Borges Joe A · Highland, CABuilt 1972 · S/N MB-557N24625Mason Ron · Tallahassee, FLBuilt 1972 · S/N MC-140N24629Hurd Jeffrey R · Gilbert, AZS/N M-1458N24631San Jose Mixer Inc · Gilroy, CABuilt 1973 · S/N M-1459N24640Olive Aviation LLC · Anchorage, AKBuilt 1973 · S/N M-1461N24645Kangas Matthew W · Covington, WABuilt 1973 · S/N MB-564N24646Kosko Stanley G · Seattle, WABuilt 1973 · S/N MB-561N24652Graber Howard J · Montgomery, INBuilt 1973 · S/N M-1430N24653Phillips Alan K · Junction City, ORBuilt 1973 · S/N MB-570N24660Arey Dale W · Laramie, WYBuilt 1973 · S/N MB-565N24662Dumay Chad · O Fallon, MOBuilt 1973 · S/N MC-139N24663Stuber Paul A · Kansas City, MOS/N M-1425N24665Axiom Development & Consulting LLC · Atlanta, GAS/N MC-147N24672Gurgainous Larry K · Fredericksburg, VABuilt 1973 · S/N MC-154N24676Goren Matthew B · Wilmette, ILBuilt 1972 · S/N M-1414N24679No Limits Aviation Inc · Hayden, IDBuilt 1973 · S/N MB-576N24693Anderson Mark D · Eureka Springs, ARBuilt 1973 · S/N M-1443N24696Lucas Charles W · Ladson, SCBuilt 1973 · S/N M-1422N246WF2 4 6 Whiskey Foxtrot LLC · Knoxville, TNBuilt 1973 · S/N M-1427N24PDRobertson Chad W · Hubbard, ORBuilt 1976 · S/N MC-411N24PQBlackburn Joseph E Jr · Richmond, VABuilt 1974 · S/N MC-227N2501WSolari Peter L · Lebanon, CTBuilt 1973 · S/N MC-155N2506WHeiss William R · Watkins, COS/N MC-165N2507WHoffman Ray Y · Elysburg, PARegistration revokedBuilt 1973 · S/N MC-190N2508WBas Part Sales LLC · Greeley, COS/N MC-166N2511WArcher Ht LLC · Noblesville, INBuilt 1973 · S/N MC-172N2512WMonroe Judy L · Keller, TXBuilt 1973 · S/N MC-174N2513WDaniel Raymond C III · Newborn, GABuilt 1973 · S/N MC-171N2514WFalandys David L · Port Orange, FLBuilt 1973 · S/N MC-178N2515WRegistered aircraftS/N MC-187N2516W4 C'S Aviation LLC · Larose, LABuilt 1973 · S/N MC-188N2519WWilliam Rainey Harper College District 512 · Palatine, ILS/N MC-194N2524WAerowave Aviation LLC · Noblesville, INBuilt 1973 · S/N MC-196N2532WFrontier Flyers LLC · Anchorage, AKBuilt 1974 · S/N MC-207N2533WH&A Aircraft Services LLC · Omaha, ARBuilt 1973 · S/N MC-208N2534WFreds Legacy LLC · Chagrin Falls, OHBuilt 1974 · S/N MC-214N2538WBeach Eric J · Middletown, NYBuilt 1974 · S/N MC-215
Back to AD 73-20-07 R2