AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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.
N6397BLayson Walter E · Calhoun, GAN6397YAsher James A · Pasadena, CAN6398WPivac Jorge I · Chandler, AZN6398YSinglepoint Technologies Corp · Richmond, VAN6399KI B Development LLC · Monahans, TXN639ARBraden Health LLC · Greensboro, NCN639CCirrusly LLC · Cheyenne, WYN639FSC&Bh LLC · Vernal, UTN639PCMenshan LLC · Weston, FLN639PWWatercross Flight Service Inc · Miami, FLN639SRShelley Leslie I · Temple, TXN63BBWild Blue Yonder LLC · Green Bay, WIN63BMDayton Aircraft Services Inc · Daytona Beach, FLN63CDKenmore Crew Leasing Inc Trustee · Bellingham, WAN63EKEdsoft Aviation LLC · Mountain View, CAN63JMBeer Galynn W · Dewitt, MIN63JNDesert Air Inc · Phoenix, AZN63KADickert Investments - Flying Dicks LLC · Cave Creek, AZN63LCLj1700 C-90-B LLC · Goodyear, AZN63MESky22 LLC · Auburn, ALN63PWValiair Lc Trustee · Casper, WYN63TLAdams Aviation Services Inc Trustee · Wilmington, DEN63VGCicero Flying Club LLC · Indianapolis, INN63YBAlgn Enterprise Capital Holdings LLC · Irvine, CAN63YHBoardwalk Aviation LLC · Lake Oswego, ORN6401HBooskye LLC · Dumas, TXN6402NManos Con Alas Aviation · Stateline, NVN6407XRobert G Whittel P A · Gainesville, FLN6408NBorders Nowell W · Edinburg, TXN6408QAftershock Marketing Inc · Henryville, PAN6409WBreedlove Joe · Skiatook, OKN6409YChino Aviation Inc · Chino, CAN640CDRegistered aircraftN640MCConston Kenneth M · Hopewell Junction, NYN640PRjs Aviation LLC · Perryville, MON6410NAerial Services Inc · Cedar Falls, IAN6412XFucaimo LLC · South Pasadena, CAN6413PAlta Air LLC · Boise, IDN6416WGallien Anthony · Livermore, CAN6417NTaylor Michael Norman · Chino Hills, CAN6419BMarshall Timothy M Trustee · Tucson, AZN6419XPernat Frank J Trustee · Chaska, MNN641DACavu Aviation LLC · Lake Geneva, WIN641MRoyo Marco · Canutillo, TXN641MMBlanton Peter · Austin, TXN641SR641sr LLC · Greeley, CON641WTN641wt LLC · Helena, MTN64200D&G Baron LLC · Helena, ARN6420YFlying Amigos Aviation LLC · Las Cruces, NMN6421YHulett Gregory · Las Vegas, NV
Back to AD 2012-10-13