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.
N138TTTtd Travel LLC · Terre Haute, INN13PJcngx LLC · New York, NYN13UARegistered aircraftN1471RLendingclub Bank Na · Boston, MAN1477PWestern Aircraft Inc · Boise, IDN147AFShields Corp · Portsmouth, NHN148CA&R Investment Property LLC · Albuquerque, NMN149DLHls Air Inc · Poway, CAN149GTTenmile1 LLC · Rochester, MNN151MVDkj Services LLC · Augusta, KSN153LGRw Charter Services LLC · Hopkinsville, KYN153XAllred Leasing LLC · Missoula, MTN156SAStandard Aviation LLC · Memphis, TNN158CCutter Flight Management Inc · Albuquerque, NMN1600WFlattop Aviation LLC · San Francisco, CAN1621MLybl Air LLC · Billings, MTN164CMaroon & Gold LLC · Albuquerque, NMN164RDIsland Park Aviation LLC · Fargo, NDN164SLife Flight Network LLC · Aurora, ORN166AFGeiger Holdings Inc · Portsmouth, NHN1677Le Loop LLC · Naples, FLN16FCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN16HQ10ke LLC · Okeechobee, FLN172AFDynasty Flight LLC · Portsmouth, NHN173CBer Company LLC · Albuquerque, NMN175WAOsprey Aviation LLC · Preston, IDN177NXLebeouf Bros Towing LLC · Houma, LAN178CMaroon And Gold LLC · Albuquerque, NMN178WFJb Air Holdings 1 LLC · College Grove, TNN179ALBank Of Utah Trustee · Salt Lake City, UTN17SEBeta Fleet LLC · South Burlington, VTN180NGCwa LLC · Saint Louis, MON183CGeorgia Air South Inc · Valdosta, GAN189AFRmz LLC · Portsmouth, NHN1919Phase 2 Aviation LLC · Miami, FLN191PEJmm Aviation LLC · Oakwood, GAN191PGDw Leasing LLC · Charlotte, NCN1921UBank Of Utah Trustee · Salt Lake City, UTN192CPaso Aviation LLC · Winsted, MNN192CPRegistered aircraftN1932HAirmax LLC · Waukee, IAN198TKEbac LLC · Wichita, KSN19AEGbny LLC · Sheridan, WYN1CWAircw LLC · Charlotte, NCN200NPRhys Vineyards LLC · Woodside, CAN201SPColorado State Patrol · Denver, CON202PEDc Ways LLC · Macon, GAN202TWTw Leasing LLC · Oxford, CTN206AFGpfp LLC · Portsmouth, NHN207NWNorthwest Concrete Products Inc · Woodward, OK
Back to AD 2012-14-15