AD 2012-04-10
Registered aircraft · 175
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:2012-04-10')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-04-10')
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:2012-04-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-04-10') 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.
N1164HHall Nathan M · Shepherd, MTN1170HBeckman Thomas J · Pocahontas, ARN1175HKrummrey Steven C · Munith, MIFirst renewal noticeN1178HLarter Edward A · Franklin, NHN1179HMann Thomas A · Ford, WAN1182HWitherspoon Alexander · Sandy, ORN1183HMelby Justin D · Stoughton, WIN1186HLozier Jesse E · Coudersport, PAN1188HWitteveen Mark J · Kodiak, AKN1192HEberhardt William G · Orland, MEN1203HZimmer Dennis DBA · Pennock, MNN1204HCompton Adam J · Wasilla, AKN1209HNelson Chester C · Little Falls, MNN1211HSchelde Jack D · Cook, MNN1220HScroggs Jack F · Anchorage, AKN1224HCorcoran Timothy J · Aurora, ORFirst renewal noticeN1226HThorvilson Samuel R · Palmer, AKN1227HSutton Aircraft Salvage LLC · Palmer, AKN1229HMattfield Weldon D · Bovey, MNFirst renewal noticeN1233HRamberg Stephen Jon · Saint Louis Park, MNN1234HSpear Tarik W · Fairbanks, AKN1235HTravis Michael D · Anchorage, AKN1240HDestefano Patrick S · Bryan, TXN1250HPhelps Lee D · Juneau, AKN1252HPallasch Cooper William · Denton, TXN1253HTschepen Leo R · Bisbee, NDN1259HSibley Dean R · Arcadia, CAN1261HGregg Larry R · Pine City, MNN1264HSaladino Matthew G · Katy, TXN1266HStoker Paul M · Wasilla, AKN1267HRetroair Restoration LLC · Big Lake, AKN1268HBbl LLC · Louisville, KYN1270HBuehlman Peter · Laveen, AZN1271HAmundson Kimber L · Eagle River, AKN1277HRegistered aircraftN1279HRichmond Brian G · Rhome, TXN1283HMurphy George W · Willow, AKN1285HWoodford John E · Madison, WIN1287HNelson Chester C · Little Falls, MNN1289HTranby Wayne A · Fargo, NDN1293HAyers Mark T · Whitney, TXN1294HWolbert Joseph P · Canton, GAN1301HFair David E · Anchorage, AKFirst renewal noticeN1302HN1302h LLC · Levering, MIN1304HShade Eric L · Dillingham, AKN1308HDoose Paul · Wheeling, ILN1309HBrodie James W · Lind, WAN1312HZadnikar Brian M · Eveleth, MNN1320HPoliti Terris P · Lake Placid, NYN1322HSynnes Greggory M · Killdeer, ND
Back to AD 2012-04-10