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.
N8154QShine Hugh D · Temple, TXN8155ASkylane Ventures LLC · Keizer, ORN815CDHotrod Aviation LLC · Greencastle, INN815DBR&R Daredevils LLC · Wilmington, DEN815GBCirrus Design Corp · Duluth, MNN815HCHci Leasing Inc · Merritt Island, FLN815JDBuilders Aviation LLC · Algona, IAN815LNasty Rancher LLC · Alpine, WYN815LAGarrettgobo LLC · Saint Augustine, FLN815MKEasley Michael · Colorado Springs, CON815PZ11 Papa Zulu LLC · Steamboat Springs, CON8162DWc&R LLC · Austin, TXN8163FCalugar Ronald C · Bunnell, FLN8163RFoothills Insurance Services LLC · Marion, NCN8163VPerleberg Patrick M · Cedar Grove, INN8164FVander Ark Jan R Trustee · Chandler, AZN8165EWw Air LLC · Templeton, CAN8165HNext Centennial Holdings LLC · Alexandria, VAN8165QStewart Robert Page · Monroe, NCN8166GRohrer John D · Belmont, CAN8167AMagic Aviation LLC · Joplin, MON8167KHues Oulton A · Norwood, MAN8168FSnyder Jeffrey L · Clarkston, MIN8168QRucks Aviation LLC · Okeechobee, FLN8168VLandau Stephen C · Whitehouse Station, NJN816CDDodson International Parts Inc · Rantoul, KSN816GHSteim Joseph M · Shirley, MAN816JTRed Angel Wings LLC · Colorado Springs, CON816LATipuani Corp · Dover, DEN816LDJazz Aviation LLC · Largo, FLN816LMKobylar Lester J · Greensboro, GAN816LNAircraft Partner Holdings Inc Trustee · BerlinN816LTSix Lima Tango LLC · Zionsville, INN816MCOghab LLC · Atlanta, GAN816MMFlight Dynamics LLC · Clifton, VAN816PPAia Alpha LLC · Henderson, NVN816RJArkansasflyingdoc LLC · Benton, ARN816RWMarco Ravace Aviation LLC · Biloxi, MSN816SCFirst Hand Transportation LLC · Lake Orion, MIN816SDCcr Inc · Tulsa, OKN816SGViking Aviation LLC · Blue Mounds, WIN816SRInalytix LLC · New York, NYN8170AAlpha Aviation LLC · Springfield, MON8170EInternational Air Services Inc Trustee · Carson City, NVN8171GEdge Air LLC · Wilmington, DEN8171PTravelplus LLC · Knoxville, TNN8171ZRidgeline LLC · Helena, MTN8173MBrazos Air LLC · Mc Gregor, TXN8174AHank'S Aviation LLC · Merrillville, INN8179QCruce Aircraft Services LLC · Clewiston, FL
Back to AD 2012-10-13