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.
N888SXDove Aviation LLC · Jackson, MSFirst renewal noticeN888SZMenlo Sierra Ventures LLC · San Mateo, CAN888UMPalus Infigo Inc · Los Angeles, CAN888VE916papa LLC · Westlake, TXN888VLOrange Rock Holdings LLC · Newark, DEN888WKSp Aviation LLC · Upper Brookville, NYN888YMV1 Aviation LLC · Little Rock, ARN888ZLAerospace Trust Management LLC Trustee · Wilmington, DEN88917Jinling Aviation LLC · Palo Alto, CAN889DBNebraska Generator Service LLC · Kearney, NEN889FTMolly Willis Ventures LLC · Albany, GAN889JPHorizon Structural Systems Inc · New Braunfels, TXN889LTPrima Air · Santa Ana, CAN889PJCirrus Design Corp · Duluth, MNN889SKB & R Aviation LLC · Bozeman, MTN889SRAircraft Guaranty Corp Trustee · Oklahoma City, OKN889TJJenkins Thomas S · Beaufort, SCN889TMEfusa Vii LLC · Glenwood Springs, CON889WVoggys Landing LLC · Laurel, MTN88BABravo Alpha Aviation LLC · Seattle, WAN88BM350 Aviation LLC · Fort Lauderdale, FLN88BPPlane LLC · Worcester, MAN88CBSonoran Swift LLC · Phoenix, AZN88CEN3mf LLC · Lewes, DEN88DZKrd Services LLC · Carefree, AZN88EZMusack Randy A · Butternut, WIN88GYHorizon Line Capital LLC · Beaverton, ORN88KKPilot Country Airport X05 LLC · Spring Hill, FLN88LHTupper Aviation LLC · Jackson, NJN88LMLr Summit LLC · Denton, TXN88MGSky Rider Transport II LLC · Milwaukee, WIN88SEN812cs LLC · Murrieta, CAN88SVDiamond Xport LLC · Naples, FLN88TSWrb Aircraft LLC · New York, NYN88VCChandler Van S · Georgetown, TXN88VMEighty-Eight Victor Mike LLC · Bentleyville, OHN88WDTrmb Aviation LLC · Gulf Breeze, FLN88WFLucky 8 Aviation LLC · Mooresville, NCN88WZInternational Air Services Inc Trustee · Carson City, NVN88XGSavvy Swine LLC · Weatherford, TXN88YPBush Michael W · Williamsport, PAN8909MCenterline Aviation LLC · Oro Valley, AZN890CAHyannis Air Service Inc DBA · Hyannis, MAN890CDTrue Course LLC · Lunenburg, MAN890DGCad Aviation LLC · San Antonio, TXN890DRCirrus Design Corp · Duluth, MNN890RDSengle Gregory R · Amherst, MAFirst renewal noticeN8911XSky West Aviation Inc Trustee · Albuquerque, NMN891ACWelshinger Douglas · Ozark, MON891ARSkytech Aviation LLC · Westlake Village, CA
Back to AD 2012-10-13