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.
N5995JYachal Benedick · Wilsey, KSN5996ACascade Mountain Vacation Rentals LLC · Cle Elum, WAN5996BStrong Brian S · Southport, NCN5996FL M W Leasing · Midlothian, TXN5996GRandle Jessica R · North Bend, ORN5996JEvergreen Flying Club Inc · Medina, WAN5996ROwens Wilbur · Rch Palos Vrd, CAN5996TLopez Manuel G · Fort Washington, MDFirst renewal noticeN5997BSpence Joseph H · Enterprise, ORN5997RVande Sandt Curtis B · Tioga, NDN5997TFour Aces Montana LLC · Missoula, MTN5998ACrow Todd R · Hinckley, MNN5998BConroy Bruce M · Martinez, CAN5998EAir Heritage Inc · Beaver Falls, PAN5998FMedic Choppers LLC · Springdale, ARN5999BBig Bird LLC · Prescott, AZN5999EBender Evan Dh · Linville, VAN599CMMscm Partners LLC · Fairfield, TXN599CPCoons Aircraft Services Inc · West Palm Beach, FLN59ABates Roger · Palm Beach Gardens, FLN59ADJohnson Rand C · Galveston, TXN59AJBird Dog Aircraft LLC · Billings, MTN59AKJaworski Roger W · Mesa, AZN59BMLissow William M · New Port Richey, FLN59CKSig Properties LLC · Helena, ARFirst renewal noticeN59EFTancredi Andrew D · Germantown, TNN59FFPeregrine Howard Partners II Lp · New Orleans, LAN59JFJpf Holdings LLC · Wilmington, DEN59KHKrause Wesley A · Big Bear City, CAN59KMMatthews Casey D · Fort Worth, TXN59LJL & J Aviation Inc · Atwater, CAN59MJSweatt Greg · Cochise, AZN59MPPilch Michael Joseph · Sheridan, WYN59PGStone Aviation Holdings LLC · Myrtle Beach, SCN59TWAb Prop Plane II LLC · Metairie, LAN59VLKelley Aircraft LLC · Weyers Cave, VAN59WAAdventist World Aviation Inc · Wilson, NCN59XPCobb John M · Fayetteville, TNN59YYBay Richard P · West Jordan, UTN5AKHackler Tara Cole · Bend, ORN5BNMountain Air Inc · Quincy, CAN5BWThompson Aubrey C · Wilmington, NCN5CMBramall Buster I · Waxahachie, TXN5CYKawasaki Clyde H · Carson City, NVN5DJMyers Bradley J · Madisonville, KYN5DTFive Delta Tango LLC · Tucson, AZN5EA310 LLC · Conover, NCN5EJJones Eric M · Southbridge, MAN5FBRichers David M · Thornton, CON5GSOllman Matthew P · Poplar Grove, IL
Back to AD 79-10-14 R1