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.

N60743Cowart Frederic D · Baytown, TXBuilt 1969 · S/N 15070540N60748Flawless Aviation LLC · Loxahatchee, FLS/N 15070544N60749Frazier Brian D · Jackson, MSBuilt 1969 · S/N 15070545N6074RKray Timothy P · Lincoln, NEBuilt 1965 · S/N 17253743N60756Vanjara Obaid U · San Ramon, CABuilt 1969 · S/N 15070551N60757Follman Aviation LLC · Waterport, NYBuilt 1969 · S/N 15070552N6075GTango Aviation Rentals LLC · Austin, TXBuilt 1969 · S/N 15071575N6075JLowrance Kathleen C · Plano, TXBuilt 1972 · S/N A1500375N6075RNelsn Hans A · Sergeant Bluff, IABuilt 1965 · S/N 17253744N60761Code 1 Flight Training LLC · Canton, TXS/N 15070556N60767Turnier Mikel W · Middletown, NYBuilt 1969 · S/N 15070561N60769Del Duca Frank J · Bethel, MEBuilt 1969 · S/N 15070563N6076GColbert Farms Inc · Davenport, WAS/N 15071576N6076RAdvanced Targeting Solutions LLC · Perkasie, PABuilt 1965 · S/N 17253745N60773Edwards Air LLC DBA · Raleigh, NCBuilt 1969 · S/N 15070566N6077RCultra Daniel L · Rochelle, ILS/N 17253746N60781Two Birds One Bear LLC · Upper Arlington, OHBuilt 1969 · S/N 15070574N60787Kenses Daniel T · Stuart, FLBuilt 1969 · S/N 15070579N6078ROancea Traian · Oakdale, CABuilt 1965 · S/N 17253747N60790Jenkins Berry E · Bell, FLBuilt 1969 · S/N 15070581N60793Registered aircraftBuilt 1969 · S/N 15070584N60796Lemanski Thomas A · Port Townsend, WABuilt 1969 · S/N 15070585N60797Portland Metro Aviation & Flying Club · Portland, ORBuilt 1969 · S/N 15070586N60798Hjl Farm Inc · Dagmar, MTS/N 15070587N6079JSmith Richard D II · Luthersville, GAS/N A1500379N60800Edens Harald E · Socorro, NMBuilt 1969 · S/N 15070588N60802Smith Jay · San Andreas, CAS/N 15070590N60808Foster William L · Waco, TXS/N 15070592N6080JRidgewood Corp Inc · Orangeville, PAFirst renewal noticeS/N A1500380N60818Bailey James C · Drummond Island, MIBuilt 1969 · S/N 15070597N6081RWatler John L · Brazil, INBuilt 1965 · S/N 17253750N60822Hawkinson Paul M · Grand Rapids, MNS/N 15070600N60825Namtvedt Erik L · Wasilla, AKBuilt 1969 · S/N 15070603N60830Ace Aviation Seminars LLC · Armuchee, GABuilt 1969 · S/N 15070606N60831Itm Aircraft LLC · North Charleston, SCBuilt 1969 · S/N 15070607N60832Pharmacures Inc · Catasauqua, PABuilt 1969 · S/N 15070608N60835Jet & Rotor Aviation LLC · Sacramento, CABuilt 1969 · S/N 15070610N60836Avz Aviation Of Tennessee Inc · Knoxville, TNBuilt 1969 · S/N 15070611N60837Howard James S · Arlington, TXS/N 15070612N6083RHatle Arlen J · Meadow, SDFirst renewal noticeBuilt 1965 · S/N 17253752N60846Erickson Daniel W · Tomales, CAS/N 15070615N6084JHatloy Mark · Drayton, NDBuilt 1973 · S/N A1500384N6084RKdb Flying LLC · Branchville, SCBuilt 1965 · S/N 17253753N60855Douglas Raymond M · Hamilton, NYBuilt 1969 · S/N 15070622N60860Joebravo Aviation LLC · Derby, KSBuilt 1969 · S/N 15070627N60861Hansen Aviation LLC · Savannah, GAS/N 15070628N60865Breitberg Benjamin D · Ridgecrest, CABuilt 1969 · S/N 15070631N60870Stracener Adam K · Pittsburg, TXBuilt 1969 · S/N 15070635N60875Registration Pending · Soldotna, AKRegistration pendingBuilt 1969 · S/N 15070638N60878Barnett Shawn N · Hartsfield, GABuilt 1969 · S/N 15070639
Back to AD 72-03-03 R3