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.

N2809FOverbaugh Gary R · Highland, UTBuilt 1966 · S/N 18256909N2809LWarner Walter M Jr · Willow, AKBuilt 1967 · S/N 17256009N2809RTerwillegar Charles E · Renton, WABuilt 1967 · S/N 18258409N2809XGuckian Jim J · Riverdale, GABuilt 1967 · S/N 17700209N280HB280hb LLC · Brighton, MIBuilt 1966 · S/N 18256901N280JGEdwards Jonathan S · Marysvale, UTBuilt 1968 · S/N 17700498N2810FDancing On Blue Lc · Las Vegas, NVBuilt 1966 · S/N 18256910N2810QMcdowell Kevin J · Williamsburg, VABuilt 1971 · S/N 17259810N2810RSeller Mark E · Hutchinson, MNBuilt 1967 · S/N 18258410N2810SWaco West Inc · Dover, DEBuilt 1967 · S/N 15066710N2811FLien Craig C · Plains, MTBuilt 1966 · S/N 18256911N2811YCotti Kevin P · Plymouth, MABuilt 1961 · S/N 18253811N2812LHarris Partnership · Conway, ARBuilt 1967 · S/N 17256012N2812QHammond David J · Chesterfield, VABuilt 1971 · S/N 17259812N2812RBullin Keith · Bryan, TXBuilt 1967 · S/N 18258412N2812XHarris Rodger C · Titusville, FLBuilt 1967 · S/N 17700212N2813FDan Air LLC · Greenville, SCBuilt 1966 · S/N 18256913N2813LFoster Neal W · Nome, AKBuilt 1967 · S/N 17256013N2813QOriginal Design Ministries · Eatonville, WABuilt 1971 · S/N 17259813N2814LStewarts Aircraft Service Inc · Waynesville, OHBuilt 1967 · S/N 17256014N2814RCypress Aviation Inc · Naples, FLBuilt 1967 · S/N 18258414N2814YYankee Tango Mike LLC · Dublin, TXS/N 18253814N2815RKimmel Aviation Insurance Agency Inc · Greenwood, MSBuilt 1967 · S/N 18258415N2815YFlakes LLC · Fort Worth, TXBuilt 1962 · S/N 18253815N2816XCoats Christopher · Vinita, OKBuilt 1967 · S/N 17700216N2818FMccullough Andrew · Lubbock, TXS/N 18256918N2818YEaton Melvin W II · Saint Onge, SDS/N 18253818N2819QAirborne LLC · Wilmington, DEBuilt 1971 · S/N 17259819N2819SBeale Frank B II · Bowling Green, VABuilt 1967 · S/N 15066719N2819XPope Steven R · Gilbert, AZBuilt 1967 · S/N 17700219N2820LHarrington Thomas W Jr · Cumming, GAS/N 17256020N2820QBush Steven B · Lago Vista, TXBuilt 1971 · S/N 17259820N2820RHutter Karl G · Reno, NVBuilt 1967 · S/N 18258420N2820XJones Michael S · Fremont, WIS/N 17700220N2821RNielson David L Trustee · Anchorage, AKBuilt 1967 · S/N 18258421N2821SHancock Jeffrey A · Jacksonville, TXS/N 15066721N2822LRobertson IV Henry B · Owensboro, KYS/N 17256022N2822XPender Michael J · Marsing, IDBuilt 1967 · S/N 17700222N2823SSpark Aero LLC · Christiansburg, VABuilt 1965 · S/N 15062301N2823XSpectron Aviation Inc · West Boylston, MAS/N 17700223N2824QAv8 LLC · Davenport, IAS/N 17259824N2824SGolf Aero Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1967 · S/N 15066724N2825FStephens Jeffrey G · Gig Harbor, WABuilt 1966 · S/N 18256925N2825ROjeda Holdings LLC · Gainesville, GABuilt 1967 · S/N 18258425N2825SShore Luke S · Elkin, NCBuilt 1967 · S/N 15066725N2825XJames Ray Inc · Twin Falls, IDS/N P206-0025N2825YSalva Kenneth J · Shingle Springs, CABuilt 1962 · S/N 18253825N2826LJamtori Investments LLC · Forrest City, ARS/N 17256026N2826QMcmillan Roger L · Camdenton, MOBuilt 1971 · S/N 17259826N2828FSmiley Neil J Trustee · Lake Havasu City, AZBuilt 1966 · S/N 18256928
Back to AD 72-03-03 R3