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.

N61001Monroe Perry M · Woodinville, WABuilt 1969 · S/N 15070724N61009Jansky Michael J · Hallettsville, TXBuilt 1969 · S/N 15070730N6100FTri Rotor Spray & Chemical · Ulysses, KSBuilt 1968 · S/N 21059000N6100GEvent Tech Services LLC · Quarryville, PABuilt 1969 · S/N 15071600N61010Hall Scotty · Cheraw, SCBuilt 1969 · S/N 15070731N61019Goodwin William J · Charlotte C H, VAS/N 15070738N61020Houk Sean R · Lyons, OHBuilt 1969 · S/N 15070739N61026Johnson David A · Dover, OHBuilt 1969 · S/N 15070744N61028Berendes Jay R · Shullsburg, WIBuilt 1969 · S/N 15070746N61030Balderrama Arturo · Mcminnville, ORBuilt 1969 · S/N 15070748N61031Pacific Aircraft Services · Aurora, ORBuilt 1969 · S/N 15070749N61033Dame John D · Omaha, NEBuilt 1969 · S/N 15070751N61038Bartholomew Howard R Jr · Mechanicsburg, PABuilt 1969 · S/N 15070755N6103NRed Leasing LLC · Juneau, AKS/N 20700194N6103RAta Auto Service Inc · Wilmington, NCBuilt 1965 · S/N T210-0003N61041Pattison Aero Inc · Upland, CABuilt 1969 · S/N 15070758N61051Crispin Michael J · Broadalbin, NYBuilt 1969 · S/N 15070765N61052Secker-Walker Hugh E · Newburyport, MAS/N 15070766N61055Booher Tabitha O · Livingston, TNBuilt 1969 · S/N 15070768N61057Provenzano Jeremy E · Aurora, COBuilt 1969 · S/N 15070770N6105FShaw Christopher S · Porterville, CABuilt 1968 · S/N 21059005N61061Townsend John J · Valliant, OKBuilt 1969 · S/N 15070773N61062Bate David F · Vanceburg, KYBuilt 1969 · S/N 15070774N61064N61064 LLC · Forest Park, ILBuilt 1969 · S/N 15070775N61067Connolly Luile A · Blaine, MNBuilt 1969 · S/N 15070777N61075Evan R Charles · Riverside, CAS/N 15070780N61077Ray Albert B · Prosser, WAS/N 15070782N61078Registered aircraftBuilt 1969 · S/N 15070783N6107GRhea Koy A · Annona, TXBuilt 1969 · S/N 15071607N61081Beattie Mark A · Anaheim, CABuilt 1969 · S/N 15070784N6108GPetrov Konstantin P · Hallandale, FLBuilt 1969 · S/N 15071608N61091O'Flynn Brian · Mimbres, NMBuilt 1969 · S/N 15070794N61094Harper Kevin J · Valley Center, KSBuilt 1969 · S/N 15070795N61097Giles David Victor · Gilbert, AZBuilt 1969 · S/N 15070798N6109RBas Part Sales LLC · Greeley, COBuilt 1965 · S/N T210-0009N61104Backwoods Air LLC · Caro, MIBuilt 1969 · S/N 15070803N61108Umrysz Jeffrey E · Mystic, CTBuilt 1969 · S/N 15070807N6110FKilmer Scott D · Fort Pierce, FLBuilt 1968 · S/N 21059010N6110GHigh Exposure Inc · Wilmington, DEBuilt 1969 · S/N 15071610N61110Veit Brett Allen · Willis, TXS/N 15070809N61112Ralph Joshua C · Wichita, KSS/N 15070811N61114Thomas O Bailey · Sutton, NDBuilt 1969 · S/N 15070813N61120Jstream Lc · Sheridan, WYBuilt 1969 · S/N 15070814N61123Starnes Robert D · Lavonia, GABuilt 1969 · S/N 15070816N61126Roth Jason G · Seattle, WABuilt 1969 · S/N 15070819N61127Mcgill Phil · Huntsville, ALBuilt 1969 · S/N 15070820N61129Jones Flying Service LLC · Pulaski, TNS/N 15070822N6112FPcb Inc · Paradise, CAS/N 21059012N61130Registration Pending · Wilmington, DERegistration pendingBuilt 1969 · S/N 15070823N61131Anderson Jerry · Vacaville, CABuilt 1969 · S/N 15070824
Back to AD 72-03-03 R3