AD 47-30-01

Registered aircraft · 2,687

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:47-30-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:47-30-01')
  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.

N1146EMj Consulting Inc · Parsons, KSBuilt 1946 · S/N 7AC4702N1148EDb Airfreight Inc · Wake Forest, NCBuilt 1946 · S/N 7AC-4704N1151ELuke Stanley W Jr · Rochester Hills, MIS/N 7AC-4707N1152ELeeds Stained Glass Co Inc · Leeds, ALBuilt 1946 · S/N 7AC-4708N1154ENewberry Richard A Sr · Springdale, ARBuilt 1946 · S/N 7AC-4710N1160ESrt Aero · Pauls Valley, OKBuilt 1946 · S/N 7AC-4716N1161EViking Champ Club · Eleva, WIS/N 7AC-4717N1162EBailey Carlton D Jr · Huntington, WVBuilt 1946 · S/N 7AC-4718N1167EGabbert Tate · Sarasota, FLBuilt 1946 · S/N 7AC-4723N1174YWolfgram Gerald D · New Hope, MNS/N 11AC-1184N1178EDills Timothy E DBA · Clymer, NYBuilt 1946 · S/N 7AC-4735N1178GAstarb John E · Baden, PAS/N 11AC-S25N1187EEsterak David R · Boyce, LABuilt 1946 · S/N 7AC-4744N11916Pleasure Air LLC · Lake Havasu City, AZBuilt 1946 · S/N 7AC-1508N1191ELawler Thomas O · Lava Hot Springs, IDBuilt 1946 · S/N 7AC-4748N1196ECofer Billie W · Double Oak, TXBuilt 1946 · S/N 7AC-4753N1197ECouch John Ainsley · Sealy, TXBuilt 1946 · S/N 7AC-4754N1200ELockner Peter Phelps · Batavia, NYBuilt 1946 · S/N 7AC-4757N1202EPinsky Heather G · Hurlburt Field, FLFirst renewal noticeS/N 7AC4759N1205ERodorigo Mark W · Virginia, MNBuilt 1946 · S/N 7AC-4762N1209EKaraty Joseph · Bates City, MOBuilt 1946 · S/N 7AC-4766N1213EWilcox Ralph G · Owensboro, KYBuilt 1946 · S/N 4771N1214EMurray Craig P · Hagaman, NYBuilt 1946 · S/N 7AC-4772N1215EConrad Kristen A · Plain City, OHBuilt 1946 · S/N 7AC-4773N1216EFrancisco Doug R · Pensacola, FLBuilt 1946 · S/N 7AC-4776N1219EPlyler Aviation Lp · Sherman, TXBuilt 1946 · S/N 7AC-4777N1221EKirsipuu Paul W · Voluntown, CTBuilt 1946 · S/N 7AC-4779N1222EMorssink Peter J · Bel Air, MDBuilt 1946 · S/N 7AC-4780N1226EPotock John M · South Riding, VABuilt 1946 · S/N 7AC-4784N1227EMccleary Timothy A · Navarre, OHBuilt 1946 · S/N 7AC-4785N1229EOriginal Design Ministries · Eatonville, WABuilt 1946 · S/N 7AC-4787N1234ELyddon Steven R · Liberal, KSBuilt 1946 · S/N 7AC-4792N1237EKing Bruce · El Paso, TXS/N 7AC-4795N1240EGevay James C · Circle Pines, MNBuilt 1946 · S/N 7AC-4798N1241EThomas Paul J · Oakland, MDS/N 7AC-4799N1244ERuppert Russell E · Dover, PABuilt 1946 · S/N 7AC-4802N1249EChez Clay LLC · Georgiana, ALS/N 7AC-4807N1251EVan Dun Egidius J · Green Cove Springs, FLBuilt 1946 · S/N 7AC-4809N1254EMiller James L · Galena, ILBuilt 1946 · S/N 7AC-4812N1255EReed Gretchen M · Madison, OHBuilt 1946 · S/N 7AC-4813N1258ECadd Jonathan A · Newberg, ORBuilt 1946 · S/N 7AC-4816N1267EJohnson Donald W · Sharpsburg, GABuilt 1946 · S/N 7AC-4825N1268EBlocker Steve J · Edgar Springs, MOBuilt 1946 · S/N 7AC-4826N1270ESteiner Zachary J · Bethlehem, CTBuilt 1946 · S/N 7AC-4828N1278EBradley Christopher · Juneau, AKS/N 7AC-4836N1282EMolek Eugene · Warren, OHBuilt 1946 · S/N 7AC-4842N1286EWilson Stuart L · Glenpool, OKBuilt 1946 · S/N 7AC-4846N1294ESouthwind Aviation Inc · Maryville, TNBuilt 1946 · S/N 7AC-4855N1296EBigger William · Partlow, VABuilt 1946 · S/N 7AC-4858N12DFGagne Gilbert R · Apple Valley, CABuilt 1946 · S/N 7AC-5050
Back to AD 47-30-01