AD 80-10-01
Registered aircraft · 2,612
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:80-10-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:80-10-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:80-10-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:80-10-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.
N1005FBeam Douglas J Trustee · Chugiak, AKN1015FInternational Air Services Inc Trustee · Carson City, NVN101APatterson Mark T · Kodiak, AKN1022FGoodfellow Malcolm D · Seattle, WAN1023FWinter Karl · Litchfield Park, AZN1028FLunoe Leif C · Anchorage, AKN1037VPulse Jeremy D · Moore, MTN103AMN103am LLC · Chehalis, WAN1040FMarrs Matthew D · Bentonville, ARN1043FBakkes Francois · Sitka, AKN1047FBondurant Jok · Talkeetna, AKN104BWJurak Mike D · Kimberly, IDN104DEVince John G · West Ossipee, NHN104HEDixie Sand And Gravel LLC · Edisto Island, SCN104NRMiller Dale D · Eagle River, AKN104RCChan Ronald G · Anchorage, AKN104TRAuburn Sheet Metal Inc · Enumclaw, WAN1050FBuchan John F · Port Ludlow, WAN1050VState Of Wisconsin · Madison, WIN1052FGlb Farms Inc · Pasco, WAN1056FBrasil John I · Lemon Grove, CAN105NBNorthcentral Aircraft LLC · Blaine, MNN1060FStrausbaugh Paul L · Clifton Forge, VAN1062FSale Reported · Independence, ORSale reportedN1074FNorth River Air LLC · Fairbanks, AKN1076FCavu Clearing LLC · Center Harbor, NHN1077ABabcock Mark E · Auburn, WAN1077FScileppi Gregory S · Sea Island, GAN1078FWilliams Casey D · Wasilla, AKN107LHale Mitchell D · Chugiak, AKN107TYThornock Ty D · Shawano, WIN1084FSiktberg Timothy J · Nashville, TNN1086LLade Burton G · Bemidji, MNN1089FWells Thomas J · Big Lake, AKN108GWPope James D · Clarkston, WAN1095FEggart Lawrence D · Nome, AKN1099FSaal Christopher J · Anchorage, AKN10JVHale Thomas O · Cotuit, MAN10KYMckinnon Laughlin Neil Trustee · Carlsbad, CAN1102GGlassy Water LLC · Brier, WAN1112TRegistration Pending · Soldotna, AKRegistration pendingN11179Holloway David · Auburn, CAN11185Stancil Joe E Jr · Eagle River, AKN111BLLandry Patrick Todd · Georgetown, TXN111CAce'S Hangar LLC · Bentonville, ARN111EYHook Steven · Pasco, WAN111EZMayes Robert C · Boise, IDN111GN111g LLC · Longmont, CON111WLCj Aero LLC · Fort Valley, VAN112GCSkywagon Ventures LLC · Chapel Hill, NC
Back to AD 80-10-01