AD 2012-13-12
Registered aircraft · 1,192
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-13-12')
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-13-12')
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-13-12') 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-13-12') 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.
N224BHBank Of Utah Trustee · Salt Lake City, UTN225DCAvion LLC · Birmingham, ALN225ELThesun LLC · Miami, FLN226MPExecutive Jet Group LLC · Opa Locka, FLN226RS226rs LLC · Cypress, TXN226SLSpencer Talia Aviation LLC · Los Angeles, CAN227SVHeritage Double Eagle LLC · Queensbury, NYN228RECape Clear LLC · Westborough, MAN2291RIngersoll Rand Inc · Davidson, NCN229KMMike Post Productions Inc · Burbank, CAN230BDGlobal Pursuits LLC · New York, NYN231CETvpx Ars Inc Trustee · North Salt Lake, UTN232FN232k LLC · Midland, TXN236CACypress Cove Air LLC · Phoenix, AZN236KRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN236LPCrest Aviation II LLC · Newport Beach, CAN237GAOrange County/Sunbird Aviation LLC · Costa Mesa, CAN237GRRed Flag Two Ltd · Miamisburg, OHN239GACentury Aviation International Inc · Wilmington, DEN239MJG4sp Holdings LLC · West Palm Beach, FLN23DQJfb3 LLC · Atlanta, GAN241CHTtx 2 LLC · Las Vegas, NVN242GMTrans-Exec Air Service Inc · Van Nuys, CAN245BDBs Farms Aviation LLC · Menlo Park, CAN245TTWotan America Inc · Fort Lauderdale, FLN2461HTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN247B247 Equipment LLC · Hillsboro Beach, FLN247EMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN247LMLive Mas Enterprises LLC · Greenwood Village, CON247PDDelphi Consulting LLC · Knoxville, TNN24JRWinbrook LLC · Los Angeles, CAN250KCFlight 444 LLC · Atlanta, GAN250RGAviation Co Inc · Cheyenne, WYN250RJDixon John W · Aurora, ORN251HRJohnson Breeders Inc · Rose Hill, NCN252DVG550 Aviation LLC · Grand Rapids, MIN254CAMmap LLC · Houston, TXN256CWSrit LLC · Irvine, CAN257ATvpx Ars Inc Trustee · North Salt Lake, UTN25CPWilmington Trust Co Trustee · Wilmington, DEN25GMLap Acquisition Air LLC · Woodbury, NYN25GVEast Coast Brokerage Services LLC · West Palm Beach, FLN25HLWilmington Trust Company Trustee · Wilmington, DEN25RARadz Airways LLC · Solana Beach, CAN25UTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN261JDMaizenblue Express LLC · Jupiter, FLN261PWPerryair LLC · New York, NYN265SHSea Hunt Boat Mfg Co Inc · Sumter, SCN267WAGlobal Aircraft LLC · Eden Prairie, MNN268VTAvire LLC · West Hollywood, CA
Back to AD 2012-13-12