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.

N1627FJrm Equipment LLC · San Francisco, CAS/N 17255022N1627QSky Time LLC · Fort Lauderdale, FLBuilt 1971 · S/N 15072927N1628QMckeeman Kevin Tee · Abilene, KSBuilt 1971 · S/N 15072928N1629FHurricane Enterprise LLC · Buffalo, WYBuilt 1966 · S/N 17255024N162BBAsbery David S · Mt Vernon, ILS/N 15073547N1632FBastion Allen L · Conton, PAS/N 17255027N1634FWings & A Prayer Gso LLC · Weaverville, NCBuilt 1966 · S/N 17255029N1636FRolfe Harold B Trustee · Holtville, CABuilt 1966 · S/N 17255031N1637FLaminar Skies Aviation LLC · Broken Arrow, OKS/N 17255032N1638FKeith Frye · El Dorado, KSS/N 17255033N1638QBeck Michael C · Farmington, CTBuilt 1971 · S/N 15072938N163LASimeon Sound LLC · Aguilares, TXBuilt 1967 · S/N 15067645N1642FRomeo Kilo Golf LLC · Asheville, NCBuilt 1966 · S/N 17255037N1642QTochman Andrew J · Avon Lake, OHBuilt 1971 · S/N 15072942N1644QBell Norman O · Hurlock, MDBuilt 1971 · S/N 15072944N1646FBowman Nathaniel Ryan · Wildwood, MOBuilt 1966 · S/N 17255041N1646QOwens Wilbur · Rancho Palos Verde, CAS/N 15072946N1647FBlue Sky Rentals LLC · Hermiston, ORBuilt 1966 · S/N 17255042N1648FBahizi Pierre Ntwali · Sterling, VAS/N 17255043N1648QPlane Connection LLC · New Bern, NCBuilt 1971 · S/N 15072948N1649FWalton Amber · Upper Sandusky, OHS/N 17255044N1650F4 Aces Air LLC · Brandon, MSS/N 17255045N1650UWilson Joshua Allen · Mckinney, TXBuilt 1974 · S/N 20700250N1651FMurphey Julian R · Knoxville, TNS/N 17255046N1653FN1653f LLC · Miami, FLBuilt 1966 · S/N 17255048N1653QDust Devil Weekend Warriors LLC · Ridgecrest, CAS/N 15072953N1655FRoughcreek Aviation LLC · Thomas, OKBuilt 1966 · S/N 17255050N1656FParagon Aviation LLC · Reading, PAS/N 17255051N1657FZaleski James A · Bonsall, CABuilt 1966 · S/N 17255052N1658FMondo Beyondo Thrill Squadron · Pasadena, CABuilt 1966 · S/N 17255053N1658QHis Kingdom Aviation · Nevada, TXS/N 15072958N1658URenfro Michael W · Bethel, AKBuilt 1974 · S/N 20700258N1659QFlying Wings Of Lousiana · Denham Springs, LABuilt 1971 · S/N 15072959N165FCPocono Mountains Flying Club Inc · Tobyhanna, PAS/N 15064575N165LADicairano Gerard J · Salisbury, MDBuilt 1967 · S/N 15066156N1660QDulitz David E · Webster, SDS/N 15072960N1661FSharp Gary · Rigby, IDS/N 17255056N1663FSixtree Foxy Blue LLC · Renton, WABuilt 1966 · S/N 17255058N1663QJohnson Steven · Cheyenne, WYBuilt 1971 · S/N 15072963N1664FGrace Christopher L · Mooresville, NCBuilt 1966 · S/N 17255059N1664QWithrow Steven D · Lubbock, TXBuilt 1971 · S/N 15072964N1666QRegistration Pending · Plymouth, MNRegistration pendingBuilt 1971 · S/N 15072966N1667FVarner Properties LLC · Bristow, OKBuilt 1966 · S/N 17255062N1668QBrunk Hubert J · Lincoln, NEBuilt 1971 · S/N 15072968N1668UUngalik Syndicate LLC · Unalakleet, AKBuilt 1975 · S/N 20700268N1669QIvy James E · Alba, TXBuilt 1971 · S/N 15072969N1670FTillamook Pilots Association · Tillamook, ORBuilt 1966 · S/N 17255065N1671QRegistered aircraftBuilt 1971 · S/N 15072971N1672QHall Donna L · Pulaski, TNS/N 15072972N1673FHopkins Ronald J · Salt Lake City, UTFirst renewal noticeBuilt 1966 · S/N 17255068
Back to AD 72-03-03 R3