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.

N66126Maine Instrument Flight · Augusta, MEBuilt 1983 · S/N M-2382N6613RPollazzi Steven N · New Hope, PABuilt 1974 · S/N MC-312N6616RVanover Kevin · Whitesburg, KYS/N MB-736N6621RRasmussen Paul A · Lakewood, CABuilt 1974 · S/N M-1606N66251T Air LLC · Bonita Springs, FLBuilt 1979 · S/N M-2178N6626DDrozs Allen P · Decatur, ILBuilt 1979 · S/N M-2179N6628EPhillips Alan K · Junction City, ORBuilt 1979 · S/N M-2181N6628JSiusta Donald W · Bryceville, FLS/N M-2182N6628RD & K Aero · Elkhart, INBuilt 1974 · S/N M-1607N6629RDempsey Yvonne Grace · Guys Mills, PABuilt 1975 · S/N M-1609N6630RGamma2 Inc · San Diego, CABuilt 1974 · S/N MC-314N66313Brazon Brian D · Belle Vernon, PABuilt 1980 · S/N M-2192N6631RCornelius Craig R · West Hartford, CTBuilt 1974 · S/N MC-313N6631ZClark Ryan D · Sequim, WAS/N M-2190N6632LSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N M-2188N66337Bales Robert · Osage Beach, MOBuilt 1979 · S/N M-2201N6633FRegistration Pending · Moses Lake, WARegistration pendingBuilt 1979 · S/N M-2196N6633RBlake Anthony B · Hallsville, TXBuilt 1979 · S/N M-2198N66344Sallee Philip L · Yucca Valley, CABuilt 1979 · S/N M-2207N66354Chesson Bradley S · Tacoma, WABuilt 1979 · S/N M-2214N6638BAhmed Gedi A · Saint Paul, MNS/N M-2217N6639DBig Bend Community College · Moses Lake, WABuilt 1979 · S/N M-2223N6651RZucha Joseph P · Rio Vista, CABuilt 1975 · S/N MB-742N6652GHenehan Brendan A · Geneva, NYBuilt 1983 · S/N M-2385N6659RGarn Darrell L · Palmetto, GABuilt 1974 · S/N MB-743N6664NN6664n Lk Aircraft Holdings LLC · Wheeling, ILBuilt 1983 · S/N M-2386N66710Big Bend Community College · Moses Lake, WABuilt 1983 · S/N M-2387N6681XSky Harbor Aviation LLC · Powder Springs, GABuilt 1983 · S/N M-2388N6698QBrager Robert L · Oxnard, CABuilt 1983 · S/N M-2391N6699SBeach Coleen W · Moncks Corner, SCS/N M-2225N67013Del Ag Aero LLC · Milton, DEBuilt 1979 · S/N M-2229N6702DMcwilliams Christopher S · Atlanta, GABuilt 1979 · S/N M-2231N6704JRussell John T · Southaven, MSBuilt 1979 · S/N M-2238N6704LSoflo Aviation LLC · Oakland Park, FLBuilt 1979 · S/N M-2240N6707XGromack Stephen · Bloomfield, NMBuilt 1980 · S/N M-2241N6708NBobby Stephen M · Dunkirk, MDBuilt 1979 · S/N M-2243N6708RStorey Timothy J · Camarillo, CABuilt 1980 · S/N M-2244N6708SWininger Spencer C · Wichita, KSBuilt 1980 · S/N M-2245N6709FMorning Star Transportation Inc · Dardanelle, ARBuilt 1979 · S/N M-2247N670MLQualitair LLC Trustee · MichelstadtBuilt 1970 · S/N MC-65N6710BBarnard Matthew Bryan · Fort Worth, TXBuilt 1980 · S/N M-2246N67123Spencer Lane Inc · Lewes, DEBuilt 1980 · S/N M-2252N67135Aviators Next Door LLC · Newnan, GAS/N M-2257N6715DHargett David · San Juan, PRBuilt 1980 · S/N M-2253N6715HFortanas Michael J · Temecula, CABuilt 1980 · S/N M-2255N6715XOleyar John A · Houston, TXBuilt 1979 · S/N M-2260N67166Milano Matthew G · The Woodlands, TXBuilt 1980 · S/N M-2261N67168Mgm Aero Flight Inc · Jordan, MNBuilt 1980 · S/N M-2262N6717KFranco Enterprises LLC · Sioux City, IABuilt 1980 · S/N M-2266N6717VPierschbacher Clifton A · Marysville, WABuilt 1980 · S/N M-2265
Back to AD 73-20-07 R2