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.

N2669XSkydive Ricks LLC · Petersburg, OHBuilt 1965 · S/N P206-0169N2670JMiw Airmen Inc · Marshalltown, IABuilt 1966 · S/N 15065670N2670LOns Bart · Kirkland, WABuilt 1967 · S/N 17255870N2671JSherman Phillip A · Mansfield, OHBuilt 1966 · S/N 15065671N2671LNbl Aviation LLC · Woodway, TXBuilt 1967 · S/N 17255871N2671RCw Equipment Rentals Inc · Biggs, CABuilt 1967 · S/N 18258371N2672FWright James F · Glenford, OHS/N 18256772N2672VWhite Robe · Castro Valley, CABuilt 1974 · S/N 177RG0649N2673JWest David V · Sandusky, OHBuilt 1966 · S/N 15065673N2673LBalcom Terry J · Shepherd, MIBuilt 1967 · S/N 17255873N2673RDouville Laura Deluea · Portland, ORBuilt 1967 · S/N 18258373N2673VJackson R N · Southlake, TXBuilt 1974 · S/N 177RG0650N2674LValley Excavation And Grading Inc · Chatsworth, CABuilt 1967 · S/N 17255874N2674VMoroil Corp · Davidson, NCBuilt 1974 · S/N 177RG0651N2674XKaiser Eric J · Milford, INBuilt 1966 · S/N P206-0174N2675FVarnado Matthew G · Denham Springs, LABuilt 1965 · S/N 18256775N2675LFoster Jeffrey W · Lexington, NCBuilt 1967 · S/N 17255875N2676LCupp Stanley J · Quilcene, WABuilt 1967 · S/N 17255876N2677FNeu Aviation LLC · Benton, LABuilt 1965 · S/N 18256777N2677XHawk Jeff · Flowermound, TXBuilt 1965 · S/N P206-0177N2678XStewart Jeffrey D · Snyder, TXBuilt 1965 · S/N P206-0178N2679FR & K Explorations Inc · Bonners Ferry, IDBuilt 1966 · S/N 18256779N2679JJupiter Flight Service And Investing LLC · Lithonia, GABuilt 1966 · S/N 15065679N2679LBartley James K · Kent, WABuilt 1967 · S/N 17255879N2679RSchultz Charles D · Webster, WIBuilt 1967 · S/N 18258379N267EEvenson Charles R · Saint Charles, MOBuilt 1972 · S/N 15074092N2680FWatkins Jeffrey M · Auburn, CABuilt 1965 · S/N 18256780N2681XZimmer Roy E Jr · Winter Park, FLBuilt 1965 · S/N P206-0181N2682JCooper David J · Gravette, ARBuilt 1966 · S/N 15065682N2682LCommonwealth Technical Services Inc · Powhatan, VABuilt 1967 · S/N 17255882N2682RRadeka Michael · East Machias, MES/N 18258382N2683RNance James H II · Grants Pass, ORBuilt 1967 · S/N 18258383N2683VPeters Robert M · Fremont, INBuilt 1975 · S/N 177RG0655N2684FFelts Anthony E · Groveland, CAS/N 18256784N2684QJastram Benjamin C · Lafayette, LABuilt 1966 · S/N 18257884N2685FBabovic Slobodan · Elm Grove, WIBuilt 1965 · S/N 18256785N2685QMcelmoyl John W · Greenfield, CABuilt 1966 · S/N 18257885N2685XWorden Andrew · Burlington, COS/N 18255311N2686FKing Cara Jean · Deland, FLBuilt 1965 · S/N 18256786N2686JMiller Mackenzie · Johnsonburg, PABuilt 1966 · S/N 15065686N2686QLines Daniel R · Roseburg, ORBuilt 1966 · S/N 18257886N2687FT Air LLC · Columbia Falls, MTBuilt 1965 · S/N 18256787N2687JBridgwater David A · Mcallen, TXBuilt 1966 · S/N 15065687N2687QKnorr John Lee · Puposky, MNBuilt 1966 · S/N 18257887N2687RSpangler Keith · Monroeville, INBuilt 1967 · S/N 18258387N2688FWagosh Aviation LLC · Flagstaff, AZBuilt 1965 · S/N 18256788N2688LParsons Joshua A · Hollis Center, MES/N 17255888N2688RShaw Thomas B · Hobbs, NMBuilt 1967 · S/N 18258388N2688VHampel Michael J · Camas, WABuilt 1975 · S/N 177RG0657N2689QKirschke John K · Seneca Falls, NYBuilt 1966 · S/N 18257889
Back to AD 72-03-03 R3