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.

N61132Whithaus Douglas A · Panama City, FLBuilt 1969 · S/N 15070825N6113GPratt Aviation Services Inc · Anchorage, AKBuilt 1969 · S/N 15071613N61140Johnson Darryl W · Fowler, COBuilt 1969 · S/N 15070831N61141Holmes Meg C · Winterport, MEBuilt 1969 · S/N 15070832N61143Hedlund Wesley H · Newburgh, MEBuilt 1969 · S/N 15070834N61144Schenk Flight Service LLC · Ainsworth, NEFirst renewal noticeBuilt 1969 · S/N 15070835N61145N61145 LLC · Seattle, WAS/N 15070836N6114RJstream Lc · Sheridan, WYS/N T210-0014N61152Cunneen Regan M · Vista, CABuilt 1969 · S/N 15070841N61156Williams Tommy J · San Angelo, TXBuilt 1969 · S/N 15070845N61157Bravo Holdings LLC · St Francis, WIBuilt 1969 · S/N 15070846N61159Stenger D James Trustee · Sonora, CABuilt 1969 · S/N 15070847N61163Miller William M · Enterprise, KSBuilt 1969 · S/N 15070851N61166Om Air LLC · Saint Louis, MOS/N 15070852N61168Sherwood Ronald R · Kathleen, GABuilt 1969 · S/N 15070854N6116GWilbur David W · Marlow, NHBuilt 1969 · S/N 15071616N6116RAirxn LLC · Williams, AZBuilt 1965 · S/N T210-0016N61172Celeste Nash · Vista, CAS/N 15070858N61176Closson Dennis L · Red Wing, MNBuilt 1969 · S/N 15070862N61177Spenner John T · Fenton, MOBuilt 1969 · S/N 15070863N61178Seman Kenneth H · Ravenna, OHBuilt 1969 · S/N 15070864N6117FBahl Lawrence S · Lottsburg, VABuilt 1968 · S/N 21059017N61182B2 W Corporation · Winona, MNBuilt 1969 · S/N 15070867N61184Lawson Gary R · Olympia, WAS/N 15070869N61186Petit Leon · Virgil, ILBuilt 1969 · S/N 15070871N61187Registration Pending · Burleson, TXRegistration pendingBuilt 1969 · S/N 15070872N61189Orr Jeffrey N · Waco, TXBuilt 1969 · S/N 15070874N61190Freed Richard H · Watervliet, MIBuilt 1969 · S/N 15070875N61192Possemato Domenic · Lincoln, NHS/N 15070877N611KHWolf Ronald T · Abbeville, LAS/N 15074824N61205Lockhart Aero LLC · Austin, TXBuilt 1969 · S/N 15070886N61206Hahlbohm Jeffrey S · Helena, MTS/N 15070887N61207Desroches John · Scottsdale, AZS/N 15070888N61208Cutone Ronald J · Old Saybrook, CTBuilt 1969 · S/N 15070889N6120FHickman Robert J · Canby, ORBuilt 1973 · S/N A1500421N61212Cole Lauren · Rockford, MIS/N 15070890N61213Madrigal Francisco Javier · Newman, CABuilt 1969 · S/N 15070891N61215Moody Bible Institute Of Chicago · Spokane Valley, WABuilt 1969 · S/N 15070892N6121FT & B Aero Enterprises Inc · Jacksonville, FLS/N 21059021N6121GMckinney Christopher D · Statesville, NCBuilt 1969 · S/N 15071621N61221Lang Christopher S · Genoa, NVBuilt 1969 · S/N 15070896N61229Rivera Carlos A · Beach Park, ILBuilt 1969 · S/N 15070902N61231US Flight Academy International Inc DBA · Post, TXBuilt 1969 · S/N 15070904N61232East Bay Trading Company LLC · Fairview, PABuilt 1969 · S/N 15070905N61233Advanced Aviation LLC · Kapolei, HIBuilt 1969 · S/N 15070906N61234Registered aircraftBuilt 1969 · S/N 15070907N6123GBoes Corey · Fostoria, OHBuilt 1969 · S/N 15071623N61243Rios Leah F · Anchorage, AKBuilt 1969 · S/N 15070913N61244Smith Rex M · Marshfield, MOS/N 15070914N61251Chickasha Wings Inc · Chickasha, OKBuilt 1969 · S/N 15070916
Back to AD 72-03-03 R3