OpenAirDocs.org
AD 72-03-03 R3

Registered aircraft · 17,027

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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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.

N34557Podgwaite Frank C III · North Haven, CTBuilt 1973 · S/N 17701873N34559Bagley John C · Schertz, TXBuilt 1973 · S/N 17701874N3455FN3455f Aviation LLC · New Blaine, ARBuilt 1966 · S/N 18257455N3455SAcute Holdings LLC · Jenks, OKBuilt 1964 · S/N 18255855N3455TCornejo Jose Valente · Scottsdale, AZBuilt 1968 · S/N 17700755N3455UBown George Morgan · Shady Shores, TXS/N 18254855N34565Moore Jason E Trustee · Port Orange, FLBuilt 1976 · S/N 177RG1006N34566Inspiring Flight · Scottsdale, AZBuilt 1973 · S/N 17701877N34568Diebel Darrel L · Okanogan, WABuilt 1973 · S/N 17701878N34569Coulter Daniel J · Mooresville, NCBuilt 1976 · S/N 177RG1007N3456UWright James R · Georgetown, CAS/N 18254856N34577Registration Pending · Page, AZRegistration pendingBuilt 1973 · S/N 17701882N34579Oliver Terry L · Polk City, FLBuilt 1973 · S/N 17701884N3457FStreet Jim A · Pilot Point, TXBuilt 1966 · S/N 18257457N3457SC Ville Flying Club · Nunica, MIBuilt 1964 · S/N 18255857N3457USelway Aviation Inc · Missoula, MTBuilt 1963 · S/N 18254857N34580Contois Richard R · Renton, WABuilt 1973 · S/N 17701885N3458FAirport Lounge Mbi LLC · Dayton, OHBuilt 1966 · S/N 18257458N3458JHoughton Raymond A · Fort Bragg, CABuilt 1967 · S/N 15066158N3458TBrown Lance D · Cottonwood, CABuilt 1968 · S/N 17700758N34592Van Cleve Cole · Cotulla, TXBuilt 1973 · S/N 17701889N34594Paschall David C · Hernando, MSBuilt 1973 · S/N 17701890N34597G2 Aviation LLC · Wheatland, WYBuilt 1973 · S/N 17701892N3459RRtd Aviation LLC · Hillsborough, NJBuilt 1967 · S/N 18258759N3459SStg LLC · Mountain Green, UTBuilt 1965 · S/N 18255859N3459UWalker Cody · Jacksboro, TXBuilt 1963 · S/N 18254859N345ALItm Aircraft LLC · Charleston, SCBuilt 1974 · S/N 20700262N345EEKielich Darryl C · Elk Grove, CABuilt 1967 · S/N 15066281N345QASale Reported · Leesburg, FLSale reported, pending cancellationBuilt 1965 · S/N 17253628N345TCCaplette Gregory A · Mariposa, CABuilt 1973 · S/N 17701887N34602Hopkins Peter Matthew · Vancouver, WABuilt 1973 · S/N 17701894N34604Mccosh John · Piedmont, OKBuilt 1973 · S/N 17701896N34606Coulter Lance A · Meeker, COBuilt 1973 · S/N 17701898N3460FCut And Snip Flyers LLC · South Weber, UTBuilt 1966 · S/N 18257460N3460LFaulkner Jeannine P · Bethel, AKBuilt 1966 · S/N U206-0760N3460TBrowning Sean · Anchorage, AKBuilt 1968 · S/N 17700760N34612Hummel Frank E · Everett, WABuilt 1973 · S/N 17701901N34614Samreth Sokham · Lorton, VAS/N 17701903N34616Gois Paul · Westfield, MABuilt 1973 · S/N 17701904N3461JSmith Stephen T · Hale, MIBuilt 1967 · S/N 15066161N3461SBoyle Gene J · Moab, UTBuilt 1964 · S/N 18255861N34620Patton Gilbert L · Merritt Island, FLBuilt 1973 · S/N 17701905N3462309y Flying Club · South Saint Paul, MNBuilt 1973 · S/N 17701906N34626Ross Amy · Los Alamos, NMBuilt 1973 · S/N 17701907N34629Gradus Magnam LLC · Ocracoke, NCBuilt 1973 · S/N 17701910N3462FBehrendt Matthew D · Winsted, CTBuilt 1966 · S/N 18257462N3462LFuss Douglas A · Fort Worth, TXBuilt 1966 · S/N U206-0762N3462TJunck Kyle D · Branson, MOBuilt 1968 · S/N 17700762N34631Norton David Thompson · Dallas, TXBuilt 1973 · S/N 17701911N34634Patterson Kathleen M · Marlborough, MABuilt 1973 · S/N 17701914
Back to AD 72-03-03 R3