AD 58-16-01
Registered aircraft · 553
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:58-16-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:58-16-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:58-16-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:58-16-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.
N1099PHansen K Brent · Captain Cook, HIN10PSCarson Glen W · Garber, OKN1106CRiver Town Aviation LLC · Williamstown, WVN1123CTuschhoff Stetson Rd · Jackson, MON1140CAtkins Alvin R · Barnstead, NHN1167CMountain Bluebird Aviation LLC · Kalispell, MTN1168CPartridge James R · Chino Valley, AZN1171CUnser Joshua D · Anchorage, AKN118UCypher Tosha · Palmer, AKN11DUMcginnis Terry S · Surprise, AZN11PAFelpel Craig D · Palmer, AKN1200CSmith Rod B · De Kalb, MON1226CFortine Joseph A · Adin, CAN1247CSmith Paul J · Fremont, OHN125RCChambers William M · Elkmont, ALN1264CCoulter Clint C · Texline, TXN1282CSpivey Harold E · Thomaston, GAN1283CZawada Matthew J · Roberts, MTN1300CSelf James M · Fennville, MIN1324CLawrence Mark J · Rouses Point, NYN1346CWorden Gail · Burt, MIN1393CHayden Daniel · North Pole, AKN1404ALindinger John I · Auburn, NEN1411APetz Matthew M · Sandpoint, IDN1415AHock Wesley S · Holbrook, NEN1418CWaaam Volunteer Flying Association LLC · Hood River, ORN1421AKoplitz Wesley D · Oshkosh, WIN1424AStacey Steve L · Hutchinson, KSN1431AKoiter Jason A · Prescott Valley, AZN1456AMcbride Michael S · Allentown, PAN1457ASanderson Michael E · Newberg, ORN1465ALarsen Caesar S · Pleasanton, CAN1469AJohnson Steven C · Cheyenne, WYN1471AJames Norris J · Kannapolis, NCN1472ASmith Wesley P · Donnelly, IDN1474ARichard Waldren LLC · Newberg, ORN1478ABehr Casper J · Neavitt, MDN1479AOlson Phillip Francis · Tenino, WAN1481AViseur Michael E · Tulsa, OKN1482CKnutsen Wayne R · Thompson, NDN1491ASale Reported · Lone Jack, MOSale reportedN1492AKessler David Keith · Mineral Wells, TXN1494AHelton Tom H · Santa Ana, CAN1495ARamos Benjamin · Yuma, AZN1497ASlagle Steven D · Auburn, WAN1498ASpivey Larry B · Milledgeville, GAN1501ASchaus Richard M · Schoolcraft, MIN1502AInternational Air Services Inc Trustee · Carson City, NVN1503PRegistered aircraftN1504AHise Kevin E · Rock Rapids, IA
Back to AD 58-16-01