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.

N3819QGulf Coast Aero Club Inc · Sarasota, FLBuilt 1971 · S/N 17259919N3819RMeznarsic Victor F · Alton, ILBuilt 1966 · S/N 17255319N3819YLaycock Justin D · Johnson City, TNBuilt 1964 · S/N 21058319N3821GI Am Alpha & Omega LLC · Sparks, NVS/N U206-0821N3821LSky Bryce Flying Club LLC · Basye, VABuilt 1965 · S/N 17253990N3822QMatanane Roke C · Barrigada, GUBuilt 1971 · S/N 17259922N3823RElectra-Vision Advertising Corp · Claremont, CABuilt 1966 · S/N 17255323N3824JBalcsik Christopher A · Tehachapi, CABuilt 1966 · S/N 15065124N3824LNewhart Manfred A · Boulder, COBuilt 1965 · S/N 17253993N3824YMclaren Richard T · Sturbridge, MABuilt 1964 · S/N 21058324N3825QFischer Roger G · Torrance, CABuilt 1971 · S/N 17259925N3825RHoogstra Jay D · Sheboygan Falls, WIBuilt 1966 · S/N 17255325N3827JCollins Camden B · Millersport, OHFirst renewal noticeS/N 15065127N3827RSeaplanes R Fun Inc · Wilmington, DEBuilt 1966 · S/N 17255327N3827YPrentice Ronald L · Winchester, CABuilt 1964 · S/N 21058327N3828YHall Edmond · Bremerton, WABuilt 1964 · S/N 21058328N3829LMustang Aviation LLC · Waterville, MEBuilt 1965 · S/N 17253998N3829QMiller Randall J · Arlington, WABuilt 1971 · S/N 17259929N3829RGibbons Warren · Toledo, OHS/N 17255329N382SMJones Darrel E · Sonoma, CABuilt 1964 · S/N 18255714N3830GAerial Transport LLC · Dover, DES/N U206-0830N3830QAero Place Flyers Inc · Urbana, ILBuilt 1971 · S/N 17259930N3830RPace Michael C · Atlanta, GABuilt 1966 · S/N 17255330N3830YRice Kevin L · Pleasant View, COBuilt 1964 · S/N 21058330N3831GPanepinto Lane L · Lafitte, LAS/N U206-0831N3832LArnold Jonah Jr · Milledgeville, GABuilt 1966 · S/N 17254001N3832RDemopoulos Chris · Dyer, INBuilt 1966 · S/N 17255332N3832YMtfg LLC · Hayden, IDS/N 21058332N3833QDowning Robert · Talent, ORBuilt 1971 · S/N 17259933N3834JRegistration Pending · Buckeye, AZRegistration pendingBuilt 1966 · S/N 15065134N3834LZoltak Aviation LLC · Perry, GABuilt 1965 · S/N 17254003N3835JSkylane Lift LLC · Cheboygan, MIBuilt 1966 · S/N 15065135N3835YCarlton Jeffery G · Great Falls, MTS/N 21058335N3836RWard David E · Quilcene, WABuilt 1966 · S/N 17255336N3837LMountain Town Flying LLC · Hammondsport, NYBuilt 1965 · S/N 17254006N3837QBaja Guided Tripps LLC · Grand Lake Stream, MEBuilt 1971 · S/N 17259937N3837YRounds Chris · Waller, TXBuilt 1964 · S/N 21058337N3838GGolden Eagle Outfitters Inc · Delta Junction, AKBuilt 1967 · S/N U206-0838N3838LBerry Charles J · Shreveport, LABuilt 1965 · S/N 17254007N3838RAviation Rentals LLC · Oakman, GABuilt 1966 · S/N 17255338N3840LMikha Marvin · Nampa, IDS/N 17254009N3841GWhetzel Michael L · Ukiah, CABuilt 1967 · S/N U206-0841N3841LFisher John J · Middlefield, OHBuilt 1965 · S/N 17254010N3842LKraupie Del Ray · Bridgeport, NES/N 17254011N3843GBash Dennis W Jr · Wasilla, AKS/N U206-0843N3843JN3843j LLC · San Antonio, TXS/N 15065143N3843RHarbor View Air LLC · Kalispell, MTBuilt 1966 · S/N 17255343N3844QSmtm Holdings Inc · Wilmington, DEBuilt 1971 · S/N 17259944N3844YManarin Roland R · Lakemont, GABuilt 1964 · S/N 21058344N3845QMacon Flying Club Inc · Macon, MOBuilt 1971 · S/N 17259945
Back to AD 72-03-03 R3