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.

N6152FFisher Wayne G Trustee · Gainesville, FLBuilt 1968 · S/N 21059052N6152VClayton Stephen C · Conyers, GABuilt 1970 · S/N 17258999N6154GGrinnell Matthew J · Auburndale, FLBuilt 1969 · S/N 15071654N6155FHalladay Roy · Erie, COBuilt 1973 · S/N A1500432N6155GChin Benny C · Chandler, AZS/N 15071655N6155RPlane + Simple LLC · Salt Lake City, UTBuilt 1965 · S/N T210-0055N6157FLa Placa Peter · Lake Havasu City, AZBuilt 1973 · S/N A1500434N6158RMahany John C · Yucca Valley, CABuilt 1965 · S/N T210-0058N615AHRusty Crate LLC · Wynne, ARS/N 17252337N615ESCampanell Garrett · Leesburg, VABuilt 1969 · S/N 18260093N615FUN615fu LLC · Nashville, TNBuilt 1962 · S/N 18254491N615WTOwensby Paul T · Fayetteville, NCBuilt 1968 · S/N 17257421N616U S D A Forest Service Fepp · Columbia, SCBuilt 1967 · S/N U206-0849N6161FBeach Bums Air LLC · Martin, GABuilt 1968 · S/N 21059061N6161GGough James L · Hesston, KSBuilt 1969 · S/N 15071661N6162RSmjd LLC · Penrose, COBuilt 1965 · S/N T210-0062N6165FMainely Lobsters · Gulf Breeze, FLBuilt 1968 · S/N 21059065N6165GPartida Carlos · Delray Beach, FLBuilt 1969 · S/N 15071665N6167FJohnson Susan J · Chelan, WABuilt 1973 · S/N A1500437N6169FWatrud Joel Carl · Waskish, MNS/N 21059069N6169GKingdom Air Corps · Sutton, AKBuilt 1969 · S/N 15071669N616WERodriguez Norberto R · Inwood, NYBuilt 1963 · S/N 18254925N6170FWilkins Raymond E · Osceola, IABuilt 1968 · S/N 21059070N6170RBrown Michael R · Huntsville, ALBuilt 1965 · S/N T210-0070N6171FDohrenwend Mark G · Owensboro, KYBuilt 1968 · S/N 21059071N6171GMission Flight Academy · Yucaipa, CAS/N 15071671N6172GTappan Scott M · Port Saint Lucie, FLBuilt 1969 · S/N 15071672N6173FLesondank Stephen M · Bellvue, COBuilt 1968 · S/N 21059073N6173RBeyer Livestock Auction LLC · Clovis, NMBuilt 1965 · S/N T210-0073N6174GMosley Gabriel T · Oak Hills, CABuilt 1969 · S/N 15071674N6175RElinoff Neal D · Telluride, COBuilt 1965 · S/N T210-0075N6176RJulius Kaleb · Mesa, COBuilt 1965 · S/N T210-0076N6182Olson Gary P · Lanesboro, MNBuilt 1965 · S/N 18256342N6185GJuel Thomas Gavin · Everett, WAS/N 15071685N6187FNuxoll Builders · Clarkston, WABuilt 1968 · S/N 21059087N6187GMiller George Chris · Lone Oak, TXBuilt 1969 · S/N 15071687N6188FSky High Adventures LLC · Wilmington, DES/N A1500441N6188RPeterson Bruce L · Brighton, COBuilt 1966 · S/N T210-0088N6189GBrule Alan R · Crookston, MNBuilt 1969 · S/N 15071689N618WWood Jim · Seminole, TXBuilt 1966 · S/N P206-0218N6192RAmbrosini Helicopters Inc · Fresno, CABuilt 1966 · S/N T210-0092N6193FRheinbolt John N · Highmore, SDBuilt 1968 · S/N 21059093N6193GHolcomb Jonathan Michael · Hollandale, MSRegistration expired, pending cancellationBuilt 1969 · S/N 15071693N6195FRegistered aircraftBuilt 1968 · S/N 21059095N6199FAcara Aviation LLC · Portage, MIS/N 21059099N6199GPerez Joseph F · Hollywood, FLBuilt 1969 · S/N 15071699N6199RSchutte Ernest C W · Abita Springs, LAS/N T210-0099N619CHOrion Works Limited · Denali Park, AKBuilt 1969 · S/N U206-1276N61JRSawyer Mark S · Simi Valley, CABuilt 1964 · S/N 18255400N61LVHolt Daniel E Jr · Fayetteville, TNBuilt 1965 · S/N 17253899
Back to AD 72-03-03 R3