AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
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:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') 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.
N8274GMorris Robert B · Star Valley, AZN8274QBravo Delta II LLC · Steamboat Springs, CON8274TTraylor Robert B · Millersview, TXN8275BVixie James G · Milton Freewater, ORN8275FStanford Michael · Victoria, TXN8275MValiair Limited Company Trustee · Casper, WYN8275QAbel Derek R · Rio Vista, CAN8275XEvans C David II · Elkhart, INN8276BHermens Stanley G · Wallowa, ORN8276ESkyview Aviation LLC · Tracy, CAN8276LFly Time Aviation LLC · San Tan Valley, AZN8276TCooper Craig S · Pasco, WAN8276UNurge Richard J · Gilroy, CAN8276YVrem Kevin · Anchorage, AKN8277BRyder Clifford J · Massapequa, NYN8277GCountry Aero LLC · Darwin, MNN8277LSillers Kim O · Sault Sainte Marie, MIN8277MBlalock Paul T · Longview, TXN8277UEdgewood Farms LLC · Groveland, NYN8278EEquinoxx Flight Systems LLC · Lawrenceville, GAN8278FIvey Joseph M · Poland, OHN8278UMattison Alan B · Petaluma, CAN8278XDepew Gerald R · Oak Ridge, TNN8279AHadley Harold C · Parma, IDN8279EHull Farms Inc · Blythe, CAN8279TGaddis James W · Steelville, MON8279ZVines Forrest Mackenzie · Bonney Lake, WAN827BWWhitby Aviation Inc · Athol, IDN827CPCivil Air Patrol · Maxwell Afb, ALN827DFBrown Edward M · Cabot, ARN827DGAfrica Inland Mission International Inc · Peachtree City, GAN827EREmbry Riddle Aeronautical University · Daytona Beach, FLN827ESAtp Aircraft 1 LLC · Wilmington, DEN827KSPlanelease LLC · Venice, CAN827MAPs N827ma LLC · Green Bay, WIN827PAJa Flight Services LLC · Sugar Grove, ILN827TWGardner Thomas W · Lincoln, MEN827VPClik Services LLC · Forestdale, MAN8280BSea Coast Aviation LLC · Conway, SCN8280ETrivedi Jay S · Skokie, ILN8280TSwift Raptor Aviation LLC · Herndon, VAN8280XRegistration Pending · Archer Lodge, NCRegistration pendingN8281EAir Plains Services Corp · Wellington, KSN8281GWidtfeldt John R · Auburn, PAN8281LSliwinski Kellyn E · Anchorage, AKN8281Q9 North LLC · Parker, CON8281UHersch Richard E · Arlington, WAN8281XStull Carl · Phoenix, AZN8281ZSpearfish Aviation Inc · Summerset, SDN8282ACole Brian S · Friday Harbor, WA
Back to AD 79-10-14 R1