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

N5355RFeauto Aviation LLC · Saint Cloud, FLBuilt 1965 · S/N 17252885N5358RVandenbosch Joseph P · Bergen, NYBuilt 1965 · S/N 17252889N5359Q620 Stanley Aviation LLC · Meridian, IDBuilt 1972 · S/N 15073259N5360RSommer Wayne · Wellsville, MOBuilt 1965 · S/N 17252891N5361QBushre David N · Janesville, WIBuilt 1972 · S/N 15073261N5362QHelderman Curtis L · Newton, NCBuilt 1972 · S/N 15073262N5362RWeinhold Dale J Trustee · Ellsworth, KSBuilt 1965 · S/N 17252893N5363RCrawford James A · Coshocton, OHBuilt 1965 · S/N 17252894N5366SCraig Daniel O · Baytown, TXS/N 18260017N5367QLeatherneck Aviation LLC · Billings, MTBuilt 1972 · S/N 15073267N5367RBrooks Gordon B Sr · Hot Springs, SDBuilt 1965 · S/N 17252899N5368QMobley Christopher M · Keysville, GAS/N 15073268N5368RBiggs Aircraft Inc · Wellston, OKBuilt 1965 · S/N 17252900N5369QAirfleet Solutions LLC · Newark, DES/N 15073269N5371RAirglas Inc · Anchorage, AKBuilt 1965 · S/N 17252904N5373QMallatt Michael N · Galena, KSBuilt 1972 · S/N 15073273N5377CAnderson Robert C · Zanesfield, OHBuilt 1977 · S/N 17702623N5378RGittlein Paul A · Wasilla, AKBuilt 1965 · S/N 17252912N5379QSky Limit Services LLC · Miami, FLBuilt 1972 · S/N 15073279N537WMWeaver John D · Susanville, CABuilt 1968 · S/N 18259483N5380QFoy Timothy D · Malvern, PABuilt 1972 · S/N 15073280N5381QAirgo Inc · Centralia, ILBuilt 1972 · S/N 15073281N5382QMiller Charles L · Mooresville, NCBuilt 1972 · S/N 15073282N5383QEight Three Quebec LLC · Arlington, VABuilt 1972 · S/N 15073283N5384Penhorwood Joshua M · Shubuta, MSBuilt 1967 · S/N R172-0238N5384RKidd Frank E Jr · Wilson, NCBuilt 1965 · S/N 17252919N5386RVargo Michael D · Fremont, OHBuilt 1965 · S/N 17252921N5387ROancea Traian · Oakdale, CAS/N 17252922N5389RTetrault David E · Largo, FLBuilt 1965 · S/N 17252925N5390QIgnarro Jessie · Bay Shore, NYS/N 15073290N5390RSmith James H · Fordyce, ARBuilt 1965 · S/N 17252926N5391QMja Aviation LLC · Channahon, ILBuilt 1972 · S/N 15073291N5392QLatitude Aviation LLC · Cedar Rapids, IAS/N 15073292N5393TTinseth Lance D Trustee · Highlands Ranch, COBuilt 1966 · S/N 18257628N5395QOwens John C · Mount Carmel, PABuilt 1972 · S/N 15073295N5396RPrecocity Academy LLC · Gibsonia, PABuilt 1965 · S/N 17252933N53MPPie In The Sky Inc · Shreveport, LABuilt 1969 · S/N 18260096N53PHHaynes Jason Allen · Justin, TXS/N A1500352N5401QMaine Center For Classic Aviation · Pittsfield, MES/N 15073301N5403QAbriam Darryl · Dahlgren, VABuilt 1972 · S/N 15073303N5403RPeterson Matthew · Overland Park, KSBuilt 1965 · S/N 17252941N5404RKoller Rex E · Athens, ALS/N 17252942N5405RPolson Taylor M · Killeen, TXBuilt 1965 · S/N 17252943N5406RMmm Enterprises LLC · Aurora, INBuilt 1965 · S/N 17252945N5407QR G V Flight Academy LLC · Bayview, TXS/N 15073307N5407RLake Area Technical College · Watertown, SDS/N 17252946N5409QOwens Anthony G · Kotzebue, AKS/N 15073309N5410RIsbell Thomas · Mountain View, ARBuilt 1965 · S/N 17252950N5412QWilson William W · Mccall, IDBuilt 1972 · S/N 15073312N5412RYoungstown Warren Development Partners · Youngstown, OHS/N 17252953
Back to AD 72-03-03 R3