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.
N5171VLisenbey Edward · Caldwell, IDN5172ABarnes Timothy Edward · Stephenville, TXN5172HMsi Fuel Management Inc · Vacaville, CAN5172RWaterhouse Roy Todd · Mccall, IDN5172WOcala Aviation Services Inc · Ocala, FLN51732Imsar LLC · Springville, UTN5173ERyznar Daniel J · Anchorage, AKN5173UKnutson Wayne R · Tioga, NDN5173VEastern Kentucky University · Richmond, KYN51748Planenutz LLC · Deland, FLN5174AWells Lavar W · Hanksville, UTN5174EBlue Sky Pilots Inc · Salem, ORN5174HFlying Finn Enterprises LLC · Wilmington, DEN5175ADenkema Richard S · Grand Rapids, MIN5175EWinston Jacob · Granbury, TXN5175NArkansas Bolt Co · Little Rock, ARN5175PSbkr LLC · Greenville, PAN5175YLutz Aviation LLC · Perkinsville, VTN5176EAirplane Money Pit LLC · Rexburg, IDN5176RRight Rudder Flight Training LLC · La Verne, CAN5176VVangorder Donna · Greenwood, ARN5177AHolden Daniel N · Anacortes, WAN5177DCross Richard G · Brewster, MNN5177EAbraham Edward C · Canadian, TXN5177HPomeroy Cattle Ranch LLC · Kalispell, MTN5177NMacelvaine William Stephen · Morro Bay, CAN51782Ranger Lumber Corp · Springfield, MAN51784Winingar Thomas M · Brock, TXN51785Photos Unlimited · Rancho Cordova, CAN5178EHughes Kenneth L Jr · Wasilla, AKN5178FTurrentine Danny H · Wolfe City, TXN5178RHampton Flying Services LLC · Portsmouth, NHN5178SG & M Aircraft Inc · Wheat Ridge, CON5178USoutheastern Oklahoma State University · Durant, OKN5178YSoutheastern Oklahoma State University · Durant, OKN51793Lindsey Richard A · Richmond, TXN51794Christiansen Aviation LLC · Wilmington, DEN5179DBlack Daniel L · Spicewood, TXN5179HFlight Time Builders Inc · Memphis, TNN5179UPower Flight LLC · Las Vegas, NVN5179VFairmont State University · Fairmont, WVN517CAFisher Richard L Jr · Saint Helens, ORN517DBBerry Bruce E · Louisville, TNN517DLDelta Leema Aviation LLC · Moncks Corner, SCN517MAKilo Charlie Aeronautics LLC · Baton Rouge, LAN517NDSunrise Aviation Inc · Ormond Beach, FLN517PCAfrican Bible Colleges Inc · Karval, CON517RANason David F · Kent, WAN517SAHalo For Freedom Warrior Foundation · Willow Park, TXN517SMMcelvain Pete R · Iowa Park, TX
Back to AD 79-10-14 R1