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.

N3581ROpheim Robert M · Duluth, MNBuilt 1965 · S/N M-754N3582RAuterman Daniel · Fithian, ILBuilt 1965 · S/N M-770N3583RKing Jamie Marie · Kintnersville, PAS/N M-759N3593RHoskins Earl R · Bryan, TXBuilt 1965 · S/N M-757N3595RTutor Bobby J · Mansfield, TXBuilt 1965 · S/N M-784N3601QWard Harry W Trustee · Williamsburg, VABuilt 1967 · S/N MA-226N3603QWray Development Inc · Menifee, CABuilt 1967 · S/N MA-203N3607QToole William Barry · Goochland, VABuilt 1967 · S/N MA-207N3613QNiec Steven M · Clio, MIBuilt 1967 · S/N M-1048N3614QMay Robert L · Spring Branch, TXBuilt 1967 · S/N MB-252N3615QPlane Safe Aircraft Maintenance Inc · Waukesha, WIS/N MB-237N3624QEkholm Bryan K · Annandale, MNBuilt 1967 · S/N MB-242N3628QJ&B Toys Inc · Wilmington, DEBuilt 1967 · S/N MA-213N3630QStar Aviation LLC · Mauston, WIBuilt 1967 · S/N MA-225N3635QFantini Real Estate LLC · Louisville, KYBuilt 1967 · S/N MB-246N3638QWinder Keven S · Castle Rock, COBuilt 1967 · S/N MB-251N3640QBenville Pete E Jr · Boonville, CABuilt 1967 · S/N MB-253N3642QPorte Elvis · Miami, FLS/N MB-262N3648QRegistration Pending · Graham, WARegistration pendingBuilt 1967 · S/N MA-233N3649QSteinberg Stephen M · Happy Valley, ORBuilt 1967 · S/N MA-234N3652QNolen David S · Wimberley, TXBuilt 1967 · S/N MA-239N3653QFlying Naked Muskteers LLC · Palm City, FLBuilt 1967 · S/N MA-240N3657QFaith Builders Family Church Inc · Rogers, ARBuilt 1968 · S/N M-1136N3658QFrey Andrew F · Kerrville, TXBuilt 1967 · S/N M-1042N3661QLong Nathan J · Huntsburg, OHS/N MA-251N3664QDiana Scott J · Wallingford, CTBuilt 1967 · S/N MA-249N3666QHighum Peter · Hernando Beach, FLBuilt 1967 · S/N MA-253N3667QLife'S A Beech LLC · Wilmington, DEBuilt 1967 · S/N MA-269N3668QPaul B Meadowbrook Pc · Albany, ORS/N MA-255N3669QMarshall Jerry W · Centennial, COBuilt 1967 · S/N MA-256N3672QDye Laura G · Whispering Pines, NCBuilt 1967 · S/N MA-262N3675QSwann Phyllis R · Madison, ALBuilt 1967 · S/N MA-266N3676QJobe Eric J · Parkville, MOBuilt 1967 · S/N MA-267N3679QBear Skin Run Llp · Clinton, NCBuilt 1967 · S/N M-1051N3684QDesmarais Arthur G · Gilford, NHBuilt 1967 · S/N M-1056N3685QEaston Bryan L · Council Bluffs, IAS/N MA-259N3687QHjelle Tim D · Malone, WIBuilt 1967 · S/N MA-270N3688QFour Musketeers LLC · Wichita, KSBuilt 1967 · S/N MA-272N3689QBusick Aviation LLC · England, ARBuilt 1967 · S/N MA-271N3691QKempf David V · San Tan Valley, AZS/N MA-276N3697YSmotrich Gary A · Yardley, PABuilt 1980 · S/N M-2294N3698QGribble David A · Marion, IABuilt 1967 · S/N MA-281N3699QHillner Kevin D · Marengo, ILS/N MA-282N3714XBig Bend Community College · Moses Lake, WABuilt 1980 · S/N M-2278N3715XBig Bend Community College · Moses Lake, WABuilt 1980 · S/N M-2283N37188Charpentier Thomas J · Santee, CAS/N M-2263N37240Green Clarence L · Hondo, TXBuilt 1980 · S/N M-2282N3728KDunham Christopher B · Atlanta, GABuilt 1980 · S/N M-2285N3730HFox Valley Aero Club Inc · Oshkosh, WIBuilt 1980 · S/N M-2287N37321Hamilton Janet S · Townsend, GABuilt 1980 · S/N M-2288
Back to AD 73-20-07 R2