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.

N2539WZavala David · Demorest, GABuilt 1974 · S/N MC-219N2545WRegistration Pending · Vienna, OHRegistration pendingBuilt 1974 · S/N MC-242N2547WBittorf Charles Shane · Clear Lake, WIBuilt 1974 · S/N MC-255N2548WGotschall Harry A · San Antonio, TXBuilt 1974 · S/N MC-257N257RD4 Flying Z'S LLC · Murfreesboro, TNS/N M-2137N26TDTamaco2 LLC · Jackson, MOBuilt 1969 · S/N M-1228N274CTGoodwin Roger I · Palm Coast, FLBuilt 1978 · S/N M-2008N280ACWhite Scarf Airways LLC · Saint Charles, MOBuilt 1979 · S/N M-2197N282GFlyguys LLC · Big Bend, WIBuilt 1973 · S/N M-1445N282LBuccaneer LLC · Naperville, ILBuilt 1974 · S/N MB-700N283GWend Roger W · Charlotte, MIBuilt 1974 · S/N MC-241N296HLMcclanahan Edward A · Apo, AEBuilt 1980 · S/N M-2275N2989Reavely Richard T · Madison, CTBuilt 1969 · S/N M-1274N299JNSpell Harry · Oregon, ILBuilt 1971 · S/N M-1315N29JRLulafay LLC · Lewes, DES/N MA-235N300JLKehoe Keith J · Marion, TXBuilt 1966 · S/N MB-134N30315Registered aircraftBuilt 1968 · S/N MA-313N316NFSteenland Mark R II · Killeen, TXBuilt 1963 · S/N M-473N319GRGuinn John F · Baxter, TNBuilt 1978 · S/N M-2080N31PAUtter Joseph Lynn · Springfield, MOBuilt 1967 · S/N MA-132N321MJPetrie David W · Mechanicville, NYBuilt 1976 · S/N M-1850N331BEBabich Leslie Paige · Lutz, FLBuilt 1981 · S/N M-2300N333JMKahl Fredric P · Monmouth, MEBuilt 1972 · S/N M-1404N33DHHarrington David · Lake Saint Louis, MOBuilt 1966 · S/N MB-4N33WAThompson Casey · Edmond, OKBuilt 1975 · S/N M-1619N3412CWilson Steve D · Sentinel, OKBuilt 1969 · S/N MA-357N345WFMullens Gregory · Spencer, OKS/N M-1815N346CSBooth Kristen E · Columbia, SCBuilt 1963 · S/N M-295N3502RWisner Francis J · China, MIBuilt 1965 · S/N M-652N3507RLoose Keith · Saint Helens, ORS/N M-662N3514RElkinton Dustin L · Moundville, MOS/N M-666N3515RJameson John M · Enid, OKBuilt 1965 · S/N M-671N3518RSchlaudt William R Jr · Lufkin, TXBuilt 1965 · S/N M-670N3519RCaskey Kenneth P · Roanoke, TXS/N M-673N3522RCypret Craig P · Kingston, NHBuilt 1965 · S/N M-681N3524RAnderson Oluf J · Rangely, COBuilt 1965 · S/N M-684N3526RHampton Allan H · Lawton, OKS/N M-688N3527RDivine Designs Home Inc · Manorville, NYS/N M-687N3530RWhitney Stephen William · Fort Myers, FLS/N M-685N3531RLusher Gregory N · Prichard, WVBuilt 1965 · S/N M-693N3539RSieradzki Richard Peter · Novi, MIS/N M-707N3544RClark Lahn F · Pasco, WAS/N M-712N3549RSchaer Christopher J · Gordon, NEBuilt 1965 · S/N M-722N3554R3554r LLC · Shickley, NEBuilt 1965 · S/N M-728N3568RKohl William H · Tipton, IABuilt 1965 · S/N M-743N3569RAviation Investment & Recreation Inc · Battle Creek, MIBuilt 1965 · S/N M-750N3570PTimbie John E · Keystone Heights, FLBuilt 1965 · S/N M-751N3571RHyde Craig C · Sonoma, CABuilt 1965 · S/N M-849N3577RMorton Douglas L · Pasadena, CABuilt 1965 · S/N M-777N3579RGrice Robert D Jr · Wayne, ILBuilt 1965 · S/N M-769
Back to AD 73-20-07 R2