AD 72-03-03 R3

Registered aircraft · 17,025

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.

N16017Maley Adam W · Shinnston, WVBuilt 1972 · S/N 15073415N16019Brown Kenneth D · Port Murray, NJS/N 17702478N1601QHesse Ginger C · Stacy, MNBuilt 1971 · S/N 15072901N16021Hill Allen W · La Junta, COBuilt 1976 · S/N 17702479N16023Carr Richard D Trustee · Stockton, MOBuilt 1976 · S/N 17702480N16026B&R Aircraft LLC · Wadsworth, OHBuilt 1972 · S/N 15073422N16029Cabrera Ramon F · Guttenberg, NJBuilt 1972 · S/N 15073424N1602FWilliams Richard E · Seaford, DEBuilt 1966 · S/N 17254997N16033Mccosh Hunter B · Fort Wainwright, AKBuilt 1972 · S/N 15073427N1603FAbouelleil Hisham · Suffield, CTS/N 17254998N16042Weaver Peter D · Davis, CABuilt 1972 · S/N 15073434N16045Dragseth Joseph M · Kenai, AKS/N 15073437N16046Sky Walker Flight School LLC · Adrian, MIBuilt 1972 · S/N 15073438N16048Maki Eric · Duncanville, TXBuilt 1972 · S/N 15073440N16049Hasselbring Ted · Nashville, TNBuilt 1972 · S/N 15073441N1604FMorse Mark H · Lake Stevens, WABuilt 1966 · S/N 17254999N1604QBuck Fifty LLC · Freeport, ILBuilt 1971 · S/N 15072904N16051Wells Michael Perry · Thompson Falls, MTBuilt 1972 · S/N 15073442N16053Drain Dennis R · Ferndale, WABuilt 1972 · S/N 15073444N16057Renner Thomas J · Williston, NDS/N 15073447N16058Northwest Wings LLC · Hillsboro, ORBuilt 1972 · S/N 15073448N16064Wyatt Scott A · Tehachapi, CABuilt 1972 · S/N 15073451N16066Thompson Derek D Jr · Dunkirk, MDBuilt 1976 · S/N 17702482N1606QChappell Nathan T · Glasgow, MTBuilt 1971 · S/N 15072906N16073Hobbs Mitchell J · The Villages, FLBuilt 1972 · S/N 15073456N16074Derstine Ernest B · Pantego, NCS/N 15073457N16079El Ghawi Andre · Venice, FLBuilt 1972 · S/N 15073461N1607FNurieva Asmar · New Smyrna Beach, FLBuilt 1966 · S/N 17255002N1607HHanson Jeffrey L · Fuquay Varina, NCBuilt 1975 · S/N 177RG0780N16080150 Flyers LLC · Waterford, MIS/N 15073462N16084Lawson Roger E · Elizabethtown, KYBuilt 1972 · S/N 15073465N16088Wyrosdick Benjamin S · Hoover, ALBuilt 1972 · S/N 15073467N1608FSmith Tim J · Leasburg, MOBuilt 1966 · S/N 17255003N16091Timm Mark W · Ithaca, NEBuilt 1972 · S/N 15073469N16093Hanus Aviation LLC · Kenyon, MNBuilt 1972 · S/N 15073471N16097Crosswind Capital LLC · Castle Rock, COBuilt 1972 · S/N 15073474N160CBBishop Christopher S · Houston, TXBuilt 1966 · S/N 15063780N160PYeager Robert F · Cuyahoga Falls, OHBuilt 1962 · S/N 18254278N16101Hatch David G · Clovis, CAS/N 15073477N16105Stevenson Rodrick Albert · Smyrna, GABuilt 1972 · S/N 15073480N16107Scheck Robert C · Chicago, ILBuilt 1972 · S/N 15073481N16108Longsroad LLC · Carefree, AZBuilt 1972 · S/N 15073482N16109Registration Pending · Mundelein, ILRegistration pendingBuilt 1972 · S/N 15073483N1610FFrahm Lon R · Colby, KSBuilt 1966 · S/N 17255005N16114Mcquaid Joseph D · Cosby, TNS/N 15073486N1611FTripp Michael J · Macon, GABuilt 1966 · S/N 17255006N1611HPlane Fun Inc Tr Trustee · Snellville, GABuilt 1975 · S/N 177RG0784N16120Av8 Flight Assets LLC · Eden Prairie, MNBuilt 1972 · S/N 15073491N16125Palmer Earl S Jr · Boise, IDBuilt 1972 · S/N 15073494N16127Skypark Inc · Wadsworth, OHBuilt 1972 · S/N 15073496
Back to AD 72-03-03 R3