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.

N9156SStickley Harold R · Wauseon, OHBuilt 1976 · S/N MC-401N9161SCarr Jack Willson · East Lansing, MIBuilt 1975 · S/N MB-785N9163SRegistration Pending · Frederick, MDRegistration pendingBuilt 1976 · S/N M-1778N9164SGreat Planes Flyers LLC · Mccook, NEBuilt 1976 · S/N MC-403N9165SHufford Christopher · Tucson, AZBuilt 1976 · S/N M-1779N9166SHarris Douglas H · Morgan, UTBuilt 1976 · S/N M-1780N9167SContinental Aviation Club Inc · Lincoln, VABuilt 1976 · S/N M-1781N9170SLee Benjamin W Trustee · Chandler, AZBuilt 1976 · S/N M-1783N9172SShuffield Brian D · Oregon House, CAS/N M-1793N9177SNabeth Jeremy S · Austin, TXBuilt 1976 · S/N M-1789N9178SSwoboda Kristin · Boise, IDBuilt 1976 · S/N MC-406N9179SCharles Clarens · Brooklyn, NYBuilt 1976 · S/N M-1800N9181SFhs Aero Co Ltd · Olathe, KSBuilt 1976 · S/N M-1798N9182SBig Bend Community College · Moses Lake, WABuilt 1975 · S/N MB-786N9183SToole William Barry · Goochland, VABuilt 1976 · S/N M-1802N9185SGrushkin Jon S · Mazon, ILBuilt 1976 · S/N M-1799N9186SHigh Flyin LLC · Canton, MSBuilt 1976 · S/N M-1805N9187SCarr Gary · Crestwood, ILBuilt 1976 · S/N MB-790N9188SVanommeren Matthew · Uniondale, NYBuilt 1976 · S/N M-1803N9193SMiller Brian P · Middletown, INBuilt 1975 · S/N MC-365N9195SBailey Thomas P · Cannelton, INBuilt 1975 · S/N MC-368N9196SSkyward Leasing Inc · Dallas, GABuilt 1975 · S/N MC-370N9197SEisenhaur Timothy · Wells, MEBuilt 1975 · S/N M-1684N9198STolton Grant D · Republic, WABuilt 1975 · S/N M-1712N9202SEstafan Fadi · Tracy, CABuilt 1975 · S/N M-1736N9204SHoward Alexander James · Coulterville, ILS/N MC-374N9206SJohnson W Norman · Stayton, ORS/N MC-375N9207SMr Woodchuck LLC · Naples, FLBuilt 1975 · S/N MC-376N9208SFrush Charles A · Burlington, NJBuilt 1975 · S/N M-1688N9210SBazemore Dennis A · Ingleside, TXBuilt 1975 · S/N MC-384N9214SC&L Aviation LLC · New London, WIBuilt 1975 · S/N M-1737N9215SGarner James L DBA · Pelham, ALBuilt 1973 · S/N M1711N9220SWard Jessica · Southport, NCBuilt 1975 · S/N MC-380N9222SSvendsen James · Center Moriches, NYBuilt 1975 · S/N M-1718N9226SSpencer Montgomery L · Clinton, SCBuilt 1975 · S/N M-1723N9229SRegistered aircraftBuilt 1975 · S/N M-1724N9230SSlominski Marcus A · Chapin, SCBuilt 1976 · S/N M-1791N9235SKaidor Jerome L · Hayward, CABuilt 1975 · S/N M-1727N9236SMahi Aviation Corp · Winter Garden, FLNon-citizen corporation, flight hours not reportedBuilt 1975 · S/N M-1728N9238SAllt International LLC · Parker, COBuilt 1976 · S/N M-1760N9239SRoyer Richard W · Winnebago, MNBuilt 1975 · S/N M-1732N923VDog House Aviation LLC · Mount Pleasant, SCBuilt 1974 · S/N M-1591N9241SCosby Asa · Weldon, CAS/N M-1734N9244SKonefal Arthur Joseph · Fairbanks, AKBuilt 1975 · S/N M-1740N9245SMowery Joseph · Orlando, FLBuilt 1975 · S/N M-1741N9251SAayan Air LLC · Westfield, MABuilt 1975 · S/N MC-387N9253SKnuth Charles Allen · Avon, INBuilt 1975 · S/N M-1750N9254SHolmes Jeffrey T · Oxford, CTBuilt 1975 · S/N M-1751N9259SAlles Harry · Greeley, COBuilt 1975 · S/N MC-389N9260SChristiansen Dee W · Kerrville, TXBuilt 1975 · S/N MB-781
Back to AD 73-20-07 R2