AD 72-03-03 R3

Registered aircraft · 17,023

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.

N1369FHoudelife Aviation LLC · Bixby, OKBuilt 1966 · S/N 17254864N136JRaichl John P · Astoria, ORBuilt 1962 · S/N 205-0136N13710Registered aircraftBuilt 1976 · S/N 17702456N1371FJones Michael Robert · Glen Rose, TXS/N 17254866N1371MPlamondon Jon Trustee · Reno, NVBuilt 1971 · S/N 177RG0081N13733Kelleher James · Nevada City, CABuilt 1976 · S/N 17702462N13734Red Bird Flyers LLC · Acton, MABuilt 1976 · S/N 17702463N1373CDoft Peter · San Diego, CAS/N 17702714N13740Gigax Steven G · Archbold, OHBuilt 1976 · S/N 17702465N13747Namund LLC · Roscommon, MIBuilt 1976 · S/N 17702466N13749Son Of Jubal Ministry LLC · Bainbridge, GAS/N 17702467N1374FHegge Luke T · Pine City, MNBuilt 1966 · S/N 17254869N1374QAdams Robert J · Syracuse, NYS/N 15072674N13756Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N 17702468N13757Nelson Robert Brett · Point Roberts, WABuilt 1976 · S/N 17702469N1375CConn James Michael · Alexandria, MNBuilt 1977 · S/N 17702715N1376FWerderich George A · Bartlett, ILBuilt 1966 · S/N 17254871N1376QPaciej Bernard P · Luzerne, PABuilt 1971 · S/N 15072676N1377CCavok LLC · Wilmington, DES/N 17702716N1377FMartinelli James · Madras, ORBuilt 1966 · S/N 17254872N1377MBuiqui Aerospace Corp · Kissimmee, FLBuilt 1972 · S/N 17260577N1378MCavok LLC · La Vergne, TNBuilt 1972 · S/N 17260578N1378QOppegard Nicholas · Eagle River, AKBuilt 1971 · S/N 15072678N137CBEdmiston Brandon L · Murray, KYBuilt 1967 · S/N R1720146N137ESWhobrey Andrew T · Bee Spring, KYBuilt 1967 · S/N 15067212N13804Henderson Jeannie · Colorado Springs, COS/N 17702470N13819Avco Patrol LLC · Lyndon, KSBuilt 1976 · S/N 17702471N1381CEagle Sky Patrol Inc · Deadwood, SDBuilt 1977 · S/N 17702718N1382FCloud 9 Aviation LLC · Scenery Hill, PABuilt 1966 · S/N 17254877N1382QRegistration Pending · Hubbard, OHRegistration pendingBuilt 1971 · S/N 15072682N1384CRedwood Area Flyers LLC · Redwood Falls, MNBuilt 1977 · S/N 17702719N1385FRautio Ian · Intl Falls, MNS/N 17254880N1385QRegister Trenton D · Wilmington, NCBuilt 1971 · S/N 15072685N1386QLee Richard B · Wasilla, AKBuilt 1971 · S/N 15072686N1387FEllis Jerald K · Fort Myers, FLBuilt 1966 · S/N 17254882N1387QHendricks Adam · Plano, TXBuilt 1971 · S/N 15072687N13892Meyers Alexander C · Pittsburgh, PABuilt 1976 · S/N 17702475N1389FBedford Aero Club Inc · Bedford, INS/N 17254884N138JPChang Denny · Easton, PABuilt 1970 · S/N 17701442N138RCBardin G W · Granville, NYBuilt 1976 · S/N 177RG0994N1391QPark Derek B · Lyons, GABuilt 1971 · S/N 15072691N1392QRegistered aircraftBuilt 1971 · S/N 15072692N13939Diessner Daniel J · New Smyrna Beach, FLBuilt 1976 · S/N 17702477N1393QBeitel Ronald Lee · Rochester, MNBuilt 1971 · S/N 15072693N1394FWeller Fred R · Saint Augustine, FLBuilt 1966 · S/N 17254889N1394QDaugherty Keith C · Venus, PABuilt 1971 · S/N 15072694N1398CBennett Eric · Warsaw, INBuilt 1977 · S/N 17702720N13BJSevcik Clint · Medford, MNS/N 21058486N13DRSchuler Edward A Jr · Hamden, CTBuilt 1966 · S/N 15064816N13HKSkycombers Flying Club Inc · Pacoima, CABuilt 1972 · S/N 17701810
Back to AD 72-03-03 R3