AD 2012-10-52
Registered aircraft · 2,750
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-52')
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-52')
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-52') 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-52') 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.
N357HRMartin Hein Ranch Co · Visalia, CAN35877Turbine Conversions Ltd · Nunica, MIN358GMTextron Aviation Inc · Wichita, KSN35909Flight1 Hsw LLC · Norwood, CON35932Tmzk Holdings LLC-1 · North Fort Myers, FLN35957Cortez Flying Service Inc · Cortez, CON35VAN27ax LLC · Tulsa, OKN361MState Of Montana Dept Of Natural Resources · Helena, MTN361SPTextron Aviation Inc · Wichita, KSN362MState Of Montana Dept Of Natural Resources · Helena, MTN365PBTruck Force One LLC · Homestead, FLN367DKBonner Carl · Farmville, NCN367TZEquipco LLC · Kalispell, MTN369BGBrantley George · Carlsbad, NMN369CVVan Bortel Aircraft Inc · Arlington, TXN369HCCornerstone Mapping Inc · Roca, NEN36RHRobin Hood Aviation LLC · Dunn, NCN36XArchangel Aviation LLC · Cleburne, TXN371MALets Fly LLC · Eugene, ORN373MAKropf Kevin G · Montrose, CON373PJRock Creek Corp · Henderson, NVN3744WTextron Aviation Inc · Wichita, KSN3746Nickravesh Niknam J · Saratoga, CAN374MEKelley Aviation LLC · Crescent, IAN375SRN375sr LLC · Hickory, NCN376MESpirit Air Inc · Salmon, IDN377CSFreetown Partners LLC · Newark, DEN377GKCholla Civil Construction LLC · Mesa, AZN377HAGrasse Louis Phillip Trustee · Saint Louis, MON377MEBrandywine Enterprises Lp · Beverly Hills, CAN378CSKerr Tractor Gp LLC · Beaumont, TXN378HDept Of The Interior · Boise, IDN378MECamelot Aviation LLC · Phoenix, AZN378SStarr William E · Eagle River, AKN379DTN379dt LLC · Naples, FLN37DPTurbo Time LLC · Mesa, AZN37EWKundel Andrew R · Muscatine, IAN37JFNexga Aircraft Inc · Greensboro, NCN37PB37pb Inc · Seattle, WAN3810Nerio Antonio · Eagle Pass, TXN381DSFlightpath Investments LLC · Ottumwa, IAN3821GI Am Alpha & Omega LLC · Sparks, NVN3841GWhetzel Michael L · Ukiah, CAN384MGMissionary Air Group Inc · Burlington, NCN385CSCosmos Holdings Group LLC · Newark, DEN385TDHomestead Helicopters Inc · Missoula, MTN3875GBurnett Ross L · Riggins, IDN388UTFree Bird Air LLC · La Crosse, WIN3891GTangent Aviation LLC · Oro Valley, AZN3895GMike Kilo Aviation LLC · Garden Ridge, TX
Back to AD 2012-10-52