AD 2012-26-16
Registered aircraft · 1,377
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-26-16')
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-26-16')
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-26-16') 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-26-16') 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.
N226AFTaylor - Smartt LLC · Portsmouth, NHN226NGValiair Limited Co Trustee · Casper, WYN226NWAnd Dont Call Me Shirley LLC · Boise, IDN226TDStone Horse Aviation Services LLC · Chatham, MAN227BMCone Aviation Cs LLC · Ocala, FLN227MFMeragals LLC · Evergreen, CON227NSDolce Vita Assets LLC · Saint Petersburg, FLN227WAKary Management LLC · Mesa, AZN228JDValiair Limited Company Trustee · Casper, WYN229NGHotel Foxtrot Logistics LLC · Branson West, MON22LPAir Pilatus 22lp LLC · Spanish Fork, UTN22NGH&J Aviation LLC · Okemos, MIN22NXAfs Group LLC · Bloomfield, NJN22NYSt John Aviation LLC · Marshfield, MAN22TBAir Entrained LLC · Middleboro, MAN230UHU-Haul Co Of Oregon · Phoenix, AZN231BWN231bw LLC · Hayden, IDN2323SLegal Air Aviation Services LLC · Baton Rouge, LAN232STSierra Tango Management LLC · Reno, NVN234AWN234aw LLC · Seattle, WAN234ERErf Flight Services LLC · Corpus Christi, TXN234RGCsc Delaware Trust Co Trustee · Wilmington, DEN2353Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN235AFJ3b LLC · Portsmouth, NHN236APWestview Payroll Services Inc · Northbrook, ILN236NXHj Aviation LLC · Vandalia, OHN237SFCrt Aviation LLC · Fayetteville, NCN237TP237tp LLC · Statesboro, GAN238LLAlphinity Air LLC · Wilmington, DEN238VMGuardian Flight LLC · Lewisville, TXN23GMMain Line Executive Travel LLC · Haverford, PAN240PWOak Street Aviation LLC · Wichita, KSN241HClassic Medical Inc · Woods Cross, UTN242JHDelta Properties Llp · Nogales, AZN242MA242ma LLC · Chicago, ILN242NGPanhandle Telecommunication Systems Inc · Guymon, OKN242SGReppert Capital Management LLC · Houston, TXN243TXTexas Department Of Public Safety · Austin, TXN244Eight Hills LLC · Seattle, WAN245HCHillsborough County Sheriffs Office · Tampa, FLN245PEReack Aviation LLC · Wilmington, DEN246ELTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN246SJSparkjoy Air LLC · Boulder, CON247AMRegistered aircraftN247CU283cu LLC · Gilcrest, CON247LCRegistered aircraftN247MKOoooia LLC · Marshalltown, IAN247MSPilatus Aircraft USA Ltd · Broomfield, CON247SHUS Government · Washington, DCN248LMPilatus Aircraft USA Ltd · Broomfield, CO
Back to AD 2012-26-16