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.
N7895VCleared For Takeoff LLC · Katonah, NYN7895XVerhalen John P Jr · Scottsville, TXN7896SPanepinto Lane · Lafitte, LAN78978Martin Gary P · Boonville, MON7897FOneonone Flight Training LLC · Hagerstown, MDN7897TFunk Kenneth E · Warner Robins, GAN7897UFischer Duane A · New Baden, ILN7898GMccutcheon Frank Jr · Scottsboro, ALN7899NUnited States Air Force Owner · Colorado Springs, CON7899UDeidiker Floyd D · West Plains, MON7899XHines Jairus B · Lenoir City, TNN7899ZJsh Farms Inc · Wapato, WAN789BGM9c146 Aviation LLC · Boynton Beach, FLN789CEBond Brent L · Clearwater, KSN789DMAllen Gary D · Eyota, MNN789EPEastbourne Holdings LLC · Woodstock, GAFirst renewal noticeN789FAAb Prop Plane II LLC · Metairie, LAN789NTjb Ent LLC · Spokane, WAN789PFSherman Aviation LLC · Fairfield, NJN789RAMiller Melanie L · Spanaway, WAN789SSummit Aircraft LLC · Seattle, WAN789TCMadden Contracting Co Inc · Minden, LAN789ZParish Charles L · Tullahoma, TNN78BKKang Byung · Kansas City, MON78BLLaukka Bruce L · West Rockport, MEN78DEStanley Ryan G · Mossyrock, WAN78ERFreeway Airport Inc · Mitchellville, MDN78FWoods Joseph Lee · Gilbert, AZN78FGMcclanahan John B · Fayetteville, GAN78KWVolz James R · Laredo, TXN78LHL & J Adventures LLC · Paris, OHN78MKNelleh LLC · Liberal, KSN78MWSymple Consulting LLC · Topeka, KSN78PCBombach James · Katy, TXN78RRWilkinson William H · Anchorage, AKN78SMZimmerman Gregory J · Iowa City, IAN78WESouth Delta Aviation Inc · West Helena, ARN78WRSwift Aviation LLC · Lampasas, TXN78WVOrange Motion Trading LLC · Las Vegas, NVN79000Kemmis Sidney C · Prophetstown, ILN79001Pau Hana Enterprises LLC Series IV · Boulder City, NVN79002Fremont Aviation Inc · Fremont, NEN79004Palmer Joe A · Meridian, IDN79009Birkholz Raymond J · Boulder, CON7900FValley Wine Exports LLC · Rollingbay, WAN7900GGreat Plains Enterprises LLC · Wilmington, OHN7900NWarren County Sheriffs Dept · Mcminnville, TNN7900UJames Timothy C · Morehead, KYN7900ZWebber Jerry D · Cleburne, TXN79012Brewer Jeremiah L · Eagle River, AK
Back to AD 79-10-14 R1