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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N1146EMj Consulting Inc · Parsons, KSN1148EDb Airfreight Inc · Wake Forest, NCN1151ELuke Stanley W Jr · Rochester Hills, MIN1152ELeeds Stained Glass Co Inc · Leeds, ALN1154ENewberry Richard A Sr · Springdale, ARN1160ESrt Aero · Pauls Valley, OKN1161EViking Champ Club · Eleva, WIN1162EBailey Carlton D Jr · Huntington, WVN1167EGabbert Tate · Sarasota, FLN1174YWolfgram Gerald D · New Hope, MNN1178EDills Timothy E DBA · Clymer, NYN1178GAstarb John E · Baden, PAN1187EEsterak David R · Boyce, LAN11916Pleasure Air LLC · Lake Havasu City, AZN1191ELawler Thomas O · Lava Hot Springs, IDN1196ECofer Billie W · Double Oak, TXN1197ECouch John Ainsley · Sealy, TXN1200ELockner Peter Phelps · Batavia, NYN1202EPinsky Heather G · Hurlburt Field, FLFirst renewal noticeN1205ERodorigo Mark W · Virginia, MNN1209EKaraty Joseph · Bates City, MON1213EWilcox Ralph G · Owensboro, KYN1214EMurray Craig P · Hagaman, NYN1215EConrad Kristen A · Plain City, OHN1216EFrancisco Doug R · Pensacola, FLN1219EPlyler Aviation Lp · Sherman, TXN1221EKirsipuu Paul W · Voluntown, CTN1222EMorssink Peter J · Bel Air, MDN1226EPotock John M · South Riding, VAN1227EMccleary Timothy A · Navarre, OHN1229EOriginal Design Ministries · Eatonville, WAN1234ELyddon Steven R · Liberal, KSN1237EKing Bruce · El Paso, TXN1240EGevay James C · Circle Pines, MNN1241EThomas Paul J · Oakland, MDN1244ERuppert Russell E · Dover, PAN1249EChez Clay LLC · Georgiana, ALN1251EVan Dun Egidius J · Green Cove Springs, FLN1254EMiller James L · Galena, ILN1255EReed Gretchen M · Madison, OHN1258ECadd Jonathan A · Newberg, ORN1267EJohnson Donald W · Sharpsburg, GAN1268EBlocker Steve J · Edgar Springs, MON1270ESteiner Zachary J · Bethlehem, CTN1278EBradley Christopher · Juneau, AKN1282EMolek Eugene · Warren, OHN1286EWilson Stuart L · Glenpool, OKN1294ESouthwind Aviation Inc · Maryville, TNN1296EBigger William · Partlow, VAN12DFGagne Gilbert R · Apple Valley, CA
Back to AD 47-30-01