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.

N5979GHargrave Michael K · Gladwin, MIBuilt 1969 · S/N 15071479N597TTTerrell David R · Smithville, TNBuilt 1969 · S/N 17701403N5980GBall Albert N · Chugiak, AKBuilt 1969 · S/N 15071480N5980RPetes LLC · Pompton Plains, NJBuilt 1965 · S/N 17253649N5981RKenney Anthony G · Oviedo, FLBuilt 1965 · S/N 17253650N5982FCharles James Brown · Littlefield, TXS/N 21058982N5984FFct Aviation LLC · Portales, NMBuilt 1968 · S/N 21058984N5984GClifton Raymond L · Pleasanton, TXS/N 15071484N5985GStanton Aviation Lc · Saint George, UTBuilt 1969 · S/N 15071485N5986FBingham Darold R · Idaho Falls, IDBuilt 1968 · S/N 21058986N5987JBoerne Flight Options LLC · Boerne, TXS/N A1500287N5991JSchutes John T Jr · Port St Joe, FLBuilt 1971 · S/N A1500291N5992GPerry Aaron O · Piqua, OHS/N 15071492N5992JLinback Ken R · Niles, MIBuilt 1971 · S/N A1500292N5993GSchoenrock Timothy · Stillman Valley, ILBuilt 1969 · S/N 15071493N5996FL M W Leasing · Midlothian, TXBuilt 1968 · S/N 21058996N5996GRandle Jessica R · North Bend, ORBuilt 1969 · S/N 15071496N5996ROwens Wilbur · Rch Palos Vrd, CAS/N 17253665N5997RVande Sandt Curtis B · Tioga, NDBuilt 1965 · S/N 17253666N5998FMedic Choppers LLC · Springdale, ARS/N 21058998N599CMMscm Partners LLC · Fairfield, TXS/N 17257970N599CPCoons Aircraft Services Inc · West Palm Beach, FLBuilt 1968 · S/N 18258960N59MJSweatt Greg · Cochise, AZBuilt 1970 · S/N 18260369N59PGStone Aviation Holdings LLC · Myrtle Beach, SCBuilt 1971 · S/N 17260347N59VLKelley Aircraft LLC · Weyers Cave, VABuilt 1971 · S/N 17259905N5BNMountain Air Inc · Quincy, CABuilt 1973 · S/N 15075144N5BWThompson Aubrey C · Wilmington, NCBuilt 1968 · S/N 15069426N5DTFive Delta Tango LLC · Tucson, AZBuilt 1970 · S/N 15071977N5EJJones Eric M · Southbridge, MAS/N 177RG0167N5FBRichers David M · Thornton, COBuilt 1966 · S/N 17255431N5JPWard Russell S · Kingman, AZS/N 15065872N5LSE&K Aero LLC · Friendswood, TXBuilt 1969 · S/N 18259862N5PTMunson George R · Westhampton, MABuilt 1972 · S/N 17260628N5RBBanasik Associates Inc · Columbus, OHBuilt 1976 · S/N 177RG0968N5RWToms Ronald C · Lena, LABuilt 1970 · S/N 17259649N60002Kirmeyer Dana L · Calhoun City, MSBuilt 1968 · S/N 15069998N6000RKreisler Curt A · Plantation, FLBuilt 1965 · S/N 17253669N60016Meassick Steven F · Mount Horeb, WIBuilt 1968 · S/N 15070005N6001GN6001g LLC · Wheeling, ILBuilt 1969 · S/N 15071501N6001JBullard Daniel C · Dallas, TXBuilt 1971 · S/N A1500301N60024Esker William D · White Mtn Lk, AZBuilt 1968 · S/N 15070011N60026Lareaux Jon R · Calumet, MIBuilt 1968 · S/N 15070013N60028Mesner Steven M · Tomah, WIBuilt 1968 · S/N 15070015N6002RZelner Gregory M · Merritt Island, FLBuilt 1965 · S/N 17253671N6003260032 LLC · Jackson, MIBuilt 1968 · S/N 15070019N60040Registration Pending · Cottage Grove, MNRegistration pendingBuilt 1968 · S/N 15070026N6004GLiberty University Aviation Dept · Lynchburg, VABuilt 1969 · S/N 15071504N6004RSeaplanes R Fun Inc · Wilmington, DEBuilt 1965 · S/N 17253673N60050Elsen Paul D · Winnebago, ILBuilt 1968 · S/N 15070035N60052Onofre- Trejo Ray · Chicago, ILBuilt 1968 · S/N 15070037
Back to AD 72-03-03 R3