AD 2012-06-17
Registered aircraft · 284
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-06-17')
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-06-17')
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-06-17') 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-06-17') 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.
N58AJSe Sfj LLC · Great Neck, NYN592FCJuno Aviation LLC · Juno Beach, FLN59APComputer Sciences Corp · Tysons, VAN59CFTailwind Holdings LLC · San Ramon, CAN606PSWorldwide Option LLC · Lewes, DEN607DDominion Energy Services Inc · Richmond, VAN609EZYates Aviation LLC · Texarkana, TXN609STWilmington Trust Co Trustee · Wilmington, DEN611JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN612AFAmeriprise Financial Inc · Oxford, CTN615TT17 South Briar Hollow Lane LLC · Brookshire, TXN622GKAircraft Holding Solutions LLC Trustee · Newark, DEN635EPla Aircraft LLC · Detroit, MIN645DCDfj LLC · Denver, CON650LGWilmington Trust Co Trustee · Wilmington, DEN663CBCb Aviation Inc · Ogden, UTN668EMBank Of Utah Trustee · Salt Lake City, UTN669TN600ty LLC · Plainview, TXN674BPTvpx Trust Co LLC Trustee · North Salt Lake, UTN675RWHighlands Group LLC · Lahaina, HIN67JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN6857FCudlob 4087 LLC · South Miami, FLN6JGJg Leasing LLC · Bradenton, FLN700MVMira Vista Aviation Inc · Irvine, CAN701WCKalihiwai Aviation LLC · Aspen, CON703BGTen Point Tours Inc · Nashville, TNN705KBRegistered aircraftN717LSN717ls LLC · Miami Beach, FLN719SASr Administrative Services LLC · Van Nuys, CAN728MHM/I Homes Of Delaware LLC · Columbus, OHN741VETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN74GGDwm Logistics LLC · San Luis Obispo, CAN76THBellevue N76th LLC · North Kingstown, RIN773LMAlko 250 LLC · San Francisco, CAN776BTHilltop Asset Holdings LLC · Saratoga Springs, NYN778CRCmr LLC · Chicago, ILN779AZPittco Aviation LLC · Memphis, TNN787JSRegistered aircraftN790DCTvpx Trust Co LLC Trustee · North Salt Lake, UTN803AGTextile Aviation LLC · Dalton, GAN808CFBoss 8 LLC · Fort Worth, TXN817AFArcadia Leasing LLC · Arcadia, WIN817DEDouble Eagle Aviation LLC · Fort Worth, TXN818BKAir Maui LLC · Oakland, CAN81GKRegistered aircraftN821CNNoble Legacy Leasing LLC · Newark, DEN824FMN824fm LLC · New York, NYN830GRGwrg450 LLC · Atlanta, GAN844CBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN844GFDiamond A Administration Company LLC · Dallas, TX
Back to AD 2012-06-17