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.

N2359RTide City Air LLC · Germantown, TNBuilt 1964 · S/N 18255459N2359XHarker Charles R · Suwanee, GABuilt 1965 · S/N 18256259N2359YWadsworth Edwin Allen · Sarasota, FLBuilt 1967 · S/N 17700159N2362RBarone Christian · Stratham, NHBuilt 1964 · S/N 18255462N2362XFort Scott Family Medicine Pa · Fort Scott, KSBuilt 1965 · S/N 18256262N2363FColumbus State Community College · Columbus, OHBuilt 1964 · S/N 21058563N2363RVertikle Enterprises LLC · Cheyenne, WYBuilt 1964 · S/N 18255463N2363XShort Joe · Clintwood, VABuilt 1965 · S/N 18256263N2363YPlane Pro Aviation LLC · Shelby, NCBuilt 1967 · S/N 17700163N2364FCarlson David G Trustee · Cape Fair, MOBuilt 1964 · S/N 21058564N2364RRegistered aircraftBuilt 1964 · S/N 18255464N2364XElkhorn Aviation LLC · Norfolk, NEBuilt 1965 · S/N 18256264N2368XD C T LLC · Wallace, IDBuilt 1965 · S/N 18256268N2369YMischel John Patrick · Salyersville, KYBuilt 1967 · S/N 17700169N236DAFalany Curtis E · Tallahassee, FLBuilt 1966 · S/N 17254466N2371RBudell Stacey M · Caldwell, IDBuilt 1964 · S/N 18255471N2371XCouch Sue A · Dewy Rose, GABuilt 1965 · S/N 18256271N2372XRegistered aircraftBuilt 1965 · S/N 18256272N2373FRlo Aviation LLC · Double Springs, ALBuilt 1965 · S/N 21058573N2374XMorrison Aircraft · Harrisburg, ARS/N 18256274N2375XBaldwin Todd K · Prescott Valley, AZBuilt 1965 · S/N 18256275N23777Erb Ralph J · Mebane, NCS/N R1720096N2377FBuoni Frank · Bakersfield, CABuilt 1965 · S/N 21058577N2377XBieker Tor M · Hood River, ORBuilt 1965 · S/N 18256277N23788Bellendir Timothy J · Fort Morgan, COBuilt 1967 · S/N R172E-0092N2379XK Fortner LLC · San Marcos, TXS/N 18256279N2379YThelwell Llansley · Frisco, TXBuilt 1967 · S/N 17700179N237CTSkymax LLC · Stanford, KYBuilt 1968 · S/N 18258819N2380RReep Nicolas K · Yakima, WABuilt 1964 · S/N 18255480N2380XGaller Mary D Trustee · Elysian, MNBuilt 1965 · S/N 18256280N2381FOops LLC · Cheyenne, WYBuilt 1965 · S/N 21058581N2381XCooper Scott J · Fellows, CABuilt 1965 · S/N 18256281N2382XRolleston Moreton M III · Canton, GABuilt 1965 · S/N 18256282N2383XComo Aviation LLC · South Weymouth, MABuilt 1965 · S/N 18256283N2383YAult Stanley K · Cinebar, WABuilt 1965 · S/N 21058583N2384XHill James P · Eagle Point, ORBuilt 1965 · S/N 18256284N2384YArea-I Flying Club LLC · Atlanta, GAS/N 17700184N2387FMitten Daniel L · Hatfield, PABuilt 1965 · S/N 21058587N2387RLeroux Fernand Dean · Lagrange, GABuilt 1964 · S/N 18255487N2388XSeiler Richard · Bozeman, MTBuilt 1965 · S/N 18256288N2388YMay James E · Nashville, GABuilt 1967 · S/N 17700188N2389RB2fh Ltd · Allentown, NJBuilt 1964 · S/N 18255489N2391FBlue Horizon Consulting LLC · Toccoa, GABuilt 1965 · S/N 21058591N2391YOleksyn Anthony · Fairport, NYBuilt 1967 · S/N 17700191N2392FDingo Aviation LLC · Kalispell, MTBuilt 1965 · S/N 21058592N2392RHarvey Aaron C · Bandon, ORS/N 18255492N2392XSmm Leasing LLC · Camp Verde, AZBuilt 1965 · S/N 18256292N2393FGreengo Aviation LLC · Temple, TXBuilt 1965 · S/N 21058593N2394FN2394 Fox LLC · Sapulpa, OKBuilt 1965 · S/N 21058594N2394XPierson Daniel · Kalispell, MTS/N 18256294
Back to AD 72-03-03 R3