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.

N164DAAv Beech Holding LLC · Mandeville, LABuilt 1966 · S/N MA-101N16727Armstrong Bernard A · Cerrillos, NMBuilt 1969 · S/N MB-444N167SDierenfeldt William Travis · Manhattan, KSS/N MC-18N16956Hollowell Baron J · Boise, IDS/N MC-132N16BDLambert Thomas E · Roland, IABuilt 1969 · S/N MB-456N16THMosquera Daniel · Miami, FLBuilt 1966 · S/N M-994N16UTWhite Alan J · Fishersville, VABuilt 1972 · S/N M-1396N174DQSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1981 · S/N M2310N1790UHarris M A · Hartford, KSBuilt 1970 · S/N MB-486N17BWLoeffler Helmut Guenter · Prattsburgh, NYBuilt 1968 · S/N MB-344N1800PRegistered aircraftBuilt 1968 · S/N MA-326N1801EValdes George · Pembroke Pines, FLS/N M-2305N1816ZWestern Anesthesia Assn · Richland, WABuilt 1981 · S/N M-232N1821BBonney Andrew · Marion, MABuilt 1976 · S/N M-1907N1822XRegistered aircraftBuilt 1981 · S/N M-2327N18251Rushing Daniel W III · Inlet Beach, FLS/N M-2329N18325Hawkins Randall F · Point Pleasant, WVBuilt 1981 · S/N M-2336N1837WChurchill Laurice U · Torrance, CABuilt 1981 · S/N M-2340N18516Maine Instrument Flight · Augusta, MEBuilt 1981 · S/N M-2344N18774Sarasota Avionics Inc · Venice, FLBuilt 1977 · S/N M-1941N18775Chesley Boyd A · Cottonwood, AZS/N MB-846N18783Bates Gary D · Niles, MIBuilt 1977 · S/N M-1945N18787Ostrowski Brian Keith · Jerome, MIBuilt 1977 · S/N M-1921N18791Registration Pending · Stevens Point, WIRegistration pendingBuilt 1977 · S/N M-1942N18795Bock Patrick D · Phoenix, AZBuilt 1977 · S/N M-1947N18861Phillips Gary O · San Rafael, CABuilt 1977 · S/N M-1953N18862Koenig Michael · Mooresville, NCBuilt 1977 · S/N M-1956N18864Burnett Robert J · Garden Valley, CABuilt 1977 · S/N M-1955N18867Wisniewski Joseph B · Ormond Beach, FLBuilt 1977 · S/N M-1954N18888Symosko Stephen · Oakdale, PABuilt 1977 · S/N MB-858N18895Jmetic Consulting LLC · Springs, TXBuilt 1977 · S/N M-1963N188BSSmith Brenda S · Livingston, TXBuilt 1977 · S/N MB-873N18918Edc Aviation LLC · Middletown, RIBuilt 1977 · S/N M-1964N18920N18920 LLC · North Canton, OHBuilt 1977 · S/N M-1967N18924Swanson Jackson Van Dorn · Gustavus, AKBuilt 1977 · S/N M-1969N18928Kokkinos Antonios H · Naples, FLBuilt 1977 · S/N M-1966N18932Weber Brandon P · Otsego, MIBuilt 1977 · S/N MB-863N18947Federer Joe E · Crane Hill, ALBuilt 1977 · S/N MB-864N18948Page Don S · Norwood, NCBuilt 1977 · S/N M-1978N18956Hanig Kraig K · Merrill, WIBuilt 1977 · S/N MB-867N18962De Plane LLC · Merrill, WIBuilt 1977 · S/N M-1982N18963Ross James R · Nampa, IDBuilt 1977 · S/N M-1984N18966Big Bend Community College · Moses Lake, WABuilt 1977 · S/N MB-869N18968Budde Michael D · Claremore, OKBuilt 1978 · S/N M-1986N18970Wheatley Consulting LLC · Picayune, MSBuilt 1977 · S/N M-1988N18972Kroll Kenneth M · Counce, TNBuilt 1977 · S/N MB-868N18977Taylor Michael D · Fountain Inn, SCBuilt 1977 · S/N M-1990N18985Light Scott Thomas · Royal Oak, MIBuilt 1977 · S/N M-1965N18990Persinger D John · Ashburn, VABuilt 1977 · S/N M-1993N18BWFarris Fred · Gladstone, MOBuilt 1969 · S/N MB-431
Back to AD 73-20-07 R2