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.
N739BCSecond Wind Aviation Corp · Friday Harbor, WAN739BEFtg Leasing LLC · Watkins, COFirst renewal noticeN739BJDuffys Aircraft Sales & Leasing Inc · Neillsville, WIN739BKSundown Robert W · Bethel, AKN739BNR&R Aero Services LLC · Eden Prairie, MNN739BTBoeing Employees Flying Assn Inc · Renton, WAN739BVBurgol Hisham · Novi, MIN739BXSkypark Inc · Wadsworth, OHN739BZTfs Air LLC · Loveland, CON739CCCitadelle Holdings LLC · Wilmington, DEN739CDKcsi Aerial Patrol Inc · Bakersfield, CAN739CMHansen Lee A · Faulkton, SDN739CNAerobiz LLC · Lewes, DEN739CPCivil Air Patrol · Maxwell Afb, ALN739CYTodd Goven Farms Inc · Turtle Lake, NDN739CZBullock Michael L · Albany, INN739DBMelbourne Flight Training LLC · Melbourne, FLN739DDRivera Carlos R · Carolina, PRN739DEWings Over Texas Holdings LLC · Denton, TXN739DFMorcom Aviation Services Inc DBA · Everett, WAN739DJKemp Kerm R · Southwest Ranches, FLN739DPMoler Darryll M · Mount Orab, OHN739DRCenterline Holdings LLC · Belgrade, MTN739DTWheelair Inc · Fairfield, CAN739DWKayo Air Service Inc · Harlingen, TXN739DXRegistration Pending · Glendale, CARegistration pendingN739DZFerrari Thomas J · Torrance, CAN739EAVpc Air Inc · Cartersville, GAN739EFDyberg Mike · Mount Vernon, WAN739EHDairy Air Inc · Wyoming, PAN739EKParker Dean · Rawlins, WYN739EPLucci Giacinto A · Nashville, MIN739ERSmitty 172 LLC · Rockford, MIN739ET2035 Holdings LLC · Las Vegas, NVN739EUStar Fleet Aviation LLC · New Albany, OHN739EYLease Aviation Inc · Waterford, MIFirst renewal noticeN739EZLow Flying Angels Inc · Folsom, CAN739FCAri Ben Aviator Inc · Fort Pierce, FLN739FDHutchinson Johnny M · Blytheville, ARN739FGWings Flight Enterprises Inc · Danville, KYN739FHR&R Aero Services LLC · Eden Prairie, MNN739FMRegistration Pending · Concord, NCRegistration pendingN739FNRussell David P · Owensboro, KYN739FPTmw Aviation LLC · Portland, ORN739FSLindsay Aviation Inc · West Seneca, NYN739FTWings Of Her Dreams Aviation LLC · Belton, TXN739FU9fu LLC · Anchorage, AKN739FYSanford Aircraft LLC · Winter Springs, FLN739FZSorbi Aviation Inc · El Cajon, CAN739GCSavage Dewey M · Newport Beach, CA
Back to AD 79-10-14 R1