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.

N640SLKoonce Gary L · Midland, TXBuilt 1965 · S/N 18256483N6410SSaunders Aviation LLC · Roanoke, TXBuilt 1967 · S/N 15067210N6411GL-Bird LLC · Hood River, ORBuilt 1970 · S/N 15071911N6413FRouse Jeffrey S · Cumming, GABuilt 1966 · S/N 15063013N6414FMessing Jeffrey B · Ruth, MIBuilt 1966 · S/N 15063014N6414GBurks Aviation Inc · Hattiesburg, MSBuilt 1970 · S/N 15071914N6415SJohnson Edward A · Columbia, SCS/N 15067215N6416GRolin Brian · Mc David, FLBuilt 1970 · S/N 15071916N6416SCerny Mark V · Canyon City, ORBuilt 1967 · S/N 15067216N6417FAdkins Ian B · Dahlonega, GABuilt 1966 · S/N 15063017N6420FWilson Christopher Derrick · Ovilla, TXBuilt 1966 · S/N 15063020N6421FBixby Paul A · Vale, ORBuilt 1966 · S/N 15063021N6421SKnutson Wayne R · Thompson, NDBuilt 1967 · S/N 15067221N6422FClark James H · Pittsfield, MABuilt 1966 · S/N 15063022N6423SBores Scott J · Huron, OHBuilt 1968 · S/N 15067223N6424GWolcott Dennis L · Jasper, FLBuilt 1971 · S/N 15071924N6424SAnderst Waldemar A · Lewiston, IDBuilt 1967 · S/N 15067224N6426GWalker Raymond C · Big Fork, MTBuilt 1970 · S/N 15071926N6426SGrothe Daniel L · Paynesville, MNBuilt 1967 · S/N 15067226N6427GWoods Eric V · Fort Washington, MDBuilt 1970 · S/N 15071927N642ABauer Thomas M · Elizabethtown, KYBuilt 1966 · S/N 18257036N6431GSoule Clauson D · Cooperstown, NYBuilt 1970 · S/N 15071931N6433SDandrea Robert · Portage, PABuilt 1967 · S/N 15067233N6435GMountain Home Aviation Llp · Mountain Home, IDBuilt 1970 · S/N 15071935N6435SCarney Paul P · Massena, NYBuilt 1967 · S/N 15067235N6436FOrnelas Miguel A · Tucson, AZBuilt 1973 · S/N A1500444N6437FWilliams Michael A · Hartsville, INBuilt 1966 · S/N 15063037N6437SFiresheets William R · Zwolle, LABuilt 1967 · S/N 15067237N6438FRegistration Pending · Everett, WARegistration pendingBuilt 1973 · S/N A1500445N6438GAero Equities LLC · Ventura, CAS/N 15071938N6439SKarren Alexander M · Herriman, UTBuilt 1967 · S/N 15067239N643GAir Leasing Inc · Evanston, ILS/N 15071543N64408Dematteis James A · Erie, PABuilt 1966 · S/N R1720104N6444GBillman Ryan Patrick · Phoenix, AZS/N 15071944N6444SKiser Douglas D · Schererville, INBuilt 1967 · S/N 15067244N6445FWalk Mason · Maryville, MOBuilt 1966 · S/N 15063045N6446GHill Jonathan T · Taylorsville, KYS/N 15071946N6447GVan Holten Robert W · Flemington, NJBuilt 1970 · S/N 15071947N6448GBradley Gilbert K · Sun Prairie, WIBuilt 1970 · S/N 15071948N6449GAlbania Emad R · Huntingtown, MDBuilt 1970 · S/N 15071949N6452FRobinson Bruce · Salinas, CABuilt 1966 · S/N 15063052N6453GBegley Scott R · Fairbanks, AKBuilt 1970 · S/N 15071953N6454SLorance Glenn E · Iola, TXBuilt 1967 · S/N 15067254N6456FAmb Parnell G · Portland, NDBuilt 1966 · S/N 15063056N6456SBecker Richard Keith · Fraser, MIBuilt 1967 · S/N 15067256N6457FPepper Christopher W · Memphis, TXBuilt 1966 · S/N 15063057N6457GN19752 LLC · Toledo, WAS/N 15071957N6458FLejcar Matthew J · Mesa, AZBuilt 1966 · S/N 15063058N6460FThorton Rod W · Barrington, RIBuilt 1966 · S/N 15063060N6461GDrewry James D · Scottsboro, ALS/N 15071961
Back to AD 72-03-03 R3