AD 2012-14-15
Registered aircraft · 832
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-14-15')
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-14-15')
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-14-15') 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-14-15') 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.
N207NXIntermountain Medical Transport LLC · Salt Lake City, UTN20JTN20jt LLC · Somers, CTN212ALAir Methods LLC · Greenwood Village, CON212MASaurenman Aviation LLC · La Verne, CAN212MFTw Leasing LLC · Oxford, CTN213ALAir Methods LLC · Greenwood Village, CON213GPc12ng LLC · Cartersville, GAN213KPMaroon & Gold LLC · Albuquerque, NMN214ALAir Methods LLC · Greenwood Village, CON214GGRegistered aircraftN214MGMullet And Grits II LLC · Muskogee, OKN214NXLife Flight Network LLC · Aurora, ORN218CRegistered aircraftN218PETourico Holiday Flights LLC · Maitland, FLN219TXTexas Department Of Public Safety · Austin, TXN219XN6049s LLC · Fullerton, CAN21NXKnobelsdorff Aviation LLC · Goodhue, MNN21WLAdams Aviation Services Inc Trustee · Wilmington, DEN221DEOtter Air Services LLC · Grand Rapids, MIN221MDSwiss Air LLC · Camp Hill, PAN221NGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN221NXMassive Prints Inc · Rancho Dominguez, CAN221RCBtfd LLC · Reno, NVN221XXN221yy Corp Trustee · Wilmington, DEN2220MObsidian Leasing LLC · Lehi, UTN222DEOtter Air Services LLC · Grand Rapids, MIN223LMLgp Hidden Oaks LLC · Fulshear, TXN2244Post-Tension Services Of Texas LLC · Dallas, TXN224SLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN226AFTaylor - 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, FLN227WAKary Management LLC · Mesa, AZN229NGHotel Foxtrot Logistics LLC · Branson West, MON22NGH&J Aviation LLC · Okemos, MIN22NXAfs Group LLC · Bloomfield, NJN22NYSt John Aviation LLC · Marshfield, MAN22TBAir Entrained LLC · Middleboro, MAN2323SLegal Air Aviation Services LLC · Baton Rouge, LAN232STSierra Tango Management LLC · Reno, NVN234AWN234aw LLC · Seattle, WAN234ERErf Flight Services LLC · Corpus Christi, TXN2353Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN235AFJ3b LLC · Portsmouth, NHN236NXHj Aviation LLC · Vandalia, OHN237SFCrt Aviation LLC · Fayetteville, NCN237TP237tp LLC · Statesboro, GAN238LLAlphinity Air LLC · Wilmington, DE
Back to AD 2012-14-15