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.
N7568SAero Plus LLC · Thermopolis, WYN7568VPawlish Andrew M · Fort Collins, CON7568XKrassovsky Viatcheslav · Berkeley, CAN7569GAirborne LLC · Wilmington, DEN7569NArctic Aviation Leasing LLC · Anchorage, AKN7569SEnginaires Aero Club Inc · Savoy, ILN7569THuddleston Garry W · Brownstown, MIN7569VLiberty Capital LLC · Kalispell, MTN756AHKincaid Linda C · North Pole, AKN756ANJelinek Tyson · Iola, KSN756AVSmith Air LLC · Cascade, IDN756AWLincoln Skyways Inc · Lincoln, CAN756BBCampbell Steven P · Annapolis, CAN756BNBeck Skydiving & Rigging LLC · Bixby, OKN756BYW Yerxa LLC · Colusa, CAN756CLEgli Sam · King Salmon, AKN756CRConnell Donna M · Belton, TXN756CTKamlowsky Scott A · Anchorage, AKN756DHDorothy M Walker Family Lp · Idaho Falls, IDN756DJSutton Aircraft Salvage LLC · Palmer, AKN756DKMeyer David A · Torrance, CAN756DLSierra Sky Aviation LLC · Kalispell, MTN756DNSkyler Aviation Inc · San Diego, CAN756DQBurgett Judson B · Fowler, INN756DUCordova Air Service Inc · Cordova, AKN756DWManos Con Alas Aviation · Stateline, NVN756EJPacker Louis M · Wasilla, AKN756ENU206 Sky LLC · Pompano Beach, FLN756ETF&W Construction Co Inc · Anchorage, AKN756EYHeartland Aviation Inc · Alliance, NEN756FMTope Transportation Co · Wasilla, AKFirst renewal noticeN756FNLevitt Charles J · Dover Plains, NYN756FUElyria Airport Partnership · Jensen Beach, FLN756GFKlaiber Carl F · Concord, NCN756GWSparrow Group LLC · Cheyenne, WYN756HC242 Six Logistics LLC · Wilmington, DEN756HQMaricopa County Sheriffs Office · Phoenix, AZN756HRPeters Aire LLC · Brainerd, MNN756HUReynolds Richard A · Marco Island, FLN756JAGv Air Inc · Medford, ORN756JCBeluga LLC · Wasilla, AKN756JGNeal J Mckenny Corp Inc · Fortuna, CAN756JTRackley Co Inc · Orland, CAN756JZBrowne Thomas J · Grass Valley, CAN756KCScaletta Enterprises LLC · Middleton, WIN756KPVne Holdings Group LLC · North Canton, OHN756LCTaiga Mining Company Inc · Anchorage, AKN756MPwc Aviation LLC · Omaha, NEN756MAFly-N-Bus Aviation LLC · Parker, CON756MPEarp Kevin W · Eagle River, AK
Back to AD 79-10-14 R1