OpenAirDocs.org
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.

N1479CBuilt Aviation LLC · Haymarket, VABuilt 1977 · S/N 17702735N147MLPatton Andrew Joseph · Andrews, INBuilt 1968 · S/N 17701000N1483QAttax LLC · Missoula, MTBuilt 1971 · S/N 15072783N1484QIntegrated Structural Services Inc · Ringgold, GABuilt 1971 · S/N 15072784N1485QMartin Aviation LLC · Bargersville, INS/N 15072785N14872Blumenthal James R · Kingman, AZBuilt 1973 · S/N U20602144N1488QTorney Sean M · Angier, NCBuilt 1971 · S/N 15072788N1489FHoover Andrew V · Jenison, MIBuilt 1966 · S/N 17254984N1492QDavison James D · Richmond, MAS/N 15072792N1493FAdventist World · Wilson, NCBuilt 1966 · S/N 17254988N1493MOverly Terrence L · Tok, AKS/N U20601493N1494FThompson Kevin L · Jefferson, TXBuilt 1966 · S/N 17254989N1494QSauter Allen · Bismarck, NDBuilt 1971 · S/N 15072794N1495CGulf Coast Helicopters Inc · Pearland, TXBuilt 1977 · S/N 17702737N1496FSmith James F · Red Springs, NCBuilt 1966 · S/N 17254991N1496QDonat Brandon L · Glendale, AZBuilt 1971 · S/N 15072796N1497FBlunk Rodney · Bettendorf, IABuilt 1966 · S/N 17254992N1498CBrutger Wayne A · Saddlebrooke, AZBuilt 1978 · S/N 17702739N1499CGalbrecht Daniel S · Arbor Vitae, WIBuilt 1978 · S/N 17702740N14AUBazzo Richard J · Broadview Heights, OHBuilt 1967 · S/N 15064814N14BLEagle Equity Inc · Valparaiso, INBuilt 1968 · S/N 17257735N14CWThornwall Gregory C · Boonsboro, MDBuilt 1969 · S/N 15070656N14GLMc Flying Club Inc · Lewistown, PABuilt 1966 · S/N 15063346N14HKTrolinger John D · Kerrville, TXBuilt 1971 · S/N 15072566N14KMRiver City Aero Club Inc · Columbus, GABuilt 1965 · S/N 17254062N14LVSmetana Louis V III · Blair, NEBuilt 1970 · S/N 21059259N14MDDaniel Development LLC · Durango, COBuilt 1962 · S/N 18254114N14NFStiles Terry D · King Salmon, AKBuilt 1968 · S/N 17256844N14WAWright Brandon C · Cave City, KYBuilt 1966 · S/N 17254217N150Beam David · Sabina, OHBuilt 1969 · S/N 15071659N15000Central District Aviation LLC · Seattle, WABuilt 1969 · S/N 17258075N1500QShoaff Mark · Lehigh, FLBuilt 1971 · S/N 15072800N1500TAguilar Honorio · Anna, TXBuilt 1965 · S/N 15061784N1505QN1505q LLC · Brunswick, GAS/N 15072805N1505TN1505t LLC · Tucson, AZBuilt 1966 · S/N P206-0212N1506QDonald A D · Plano, TXBuilt 1971 · S/N 15072806N1507QSafety In Motion Flight Center Inc · Puyallup, WABuilt 1971 · S/N 15072807N1509QBeavers David · Strasburg, COBuilt 1971 · S/N 15072809N150ARBerry Norman R · Knoxville, TNS/N 15070693N150BKTribec Inc · Medina, OHBuilt 1969 · S/N 15070857N150BNHernandez Ralph · San Antonio, TXS/N 15072767N150BPRiffle Christopher Thomas · Charleston, SCBuilt 1972 · S/N 15073931N150BWRollinson Mark H · South CanterburyS/N 15064521N150CEBrazier Glen A · Greenbush, MNBuilt 1973 · S/N 15073986N150CGRomano Brian P · Terryville, CTBuilt 1967 · S/N 15066615N150CMDunn James W · Otis, MES/N 15066599N150CQCalarco Richard A · Hillsboro, ORBuilt 1965 · S/N 15061671N150CVMmdt Aero LLC · Worthington, OHBuilt 1966 · S/N 15065496N150DBEvans Thomas J · Little Elm, TXBuilt 1972 · S/N 15074052N150DDFuentes Daniel · Coral Springs, FLBuilt 1973 · S/N 15075327
Back to AD 72-03-03 R3