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.
N44PForester Dwain E · Tonopah, NVN44PYSegler Angela U · Marco Island, FLN44RBAmj Air LLC · Holland, MIN44RCPeterson Matthew W · Ethel, LAN44RPCook Aviation Services LLC · Fargo, NDN44STTakvorian Sevag · West New York, NJN44TBPacific Horizon LLC · Eagle, IDN44TUOglesby John B · Graford, TXN44UDB & K Aviation LLC · Danville, CAN44WHKelly Sean R · Bozeman, MTN44XPFurnace Joel Ray · Golden, CON44XWMinnehan Land & Cattle · Joplin, MTN4500BStartin Brandon Lee · Spokane, WAN4500CLynch Dana L · Fairbanks, AKN4500UButler Dale K · Hillsborough, NCN4501EOptima Aviation LLC DBA · Lewisville, TXN4501UPruzek Russell T · New Auburn, WIN45023New Joel · Waco, TXN45028Witke Ray · Menomonie, WIN4502BAshcraft Dustin William · Anchorage, AKN4502CMcfarland Keith A · Oklahoma City, OKN4502NSchoonover Traci L · Weyerhaeuser, WIN4502UWise Joseph D · Kilgore, TXN45031Stahla Russell · Girdwood, AKN45034Coffelt Roy · Nampa, IDN45045Lingle Gordon D · Gun Barrel City, TXN4504CHickle William H · Inyokern, CAN4504NHayton James B · Sedro Woolley, WAN45058Red Cardinal Aviation LLC · Chantilly, VAN4505UYates Kenneth E · Meridian, MSN45060Stone Eric · Cedarpines Park, CAN4506CIliamna Copper River Fly Fishing Lodge LLC · Livingston, MTN4506UBryson James D · Casstown, OHN45073Trailing Edge LLC · Elmira, NYN4507FRodriguez Kenneth C · East Wenatchee, WAN45080Todd Doug A · Dewitt, IAN45082Long Robert D · Kinston, NCN45086Dahl Ken L · Granite Falls, MNN4508FStotz Jon · Rockford, MIN4509BTrompeter Mark S · Intl Falls, MNN4509CReams Thomas M · Panacea, FLN450DHHewitt Rod · Federal Way, WAN450EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN450JTN450jt LLC · Colleyville, TXN4510CAyres Vance · Harrison, ARN4510UOrsak Chris L · Seymour, TXN45112Iaba LLC · Norfolk, VAN45115Jiang Jun · Fremont, CAN4511EN2893e LLC · Reno, NVN45128Bowker James K · Ponca City, OK
Back to AD 79-10-14 R1