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.
N206AGDesevarg Inc · Appleton, WIN206AMLiu Ke · Millburn, NJN206AZGrant Investments LLC · Bakersfield, CAN206BABoeing Company · Mesaon, AZN206BDBge Aviation LLC · Camden, ARN206BSBlue Star Gas Fleet Services Co · Central Point, ORN206CTextron Aviation Inc · Wichita, KSN206CCCharlie Charlie LLC · Wasilla, AKN206CTDe Creeft Joseph M · Homer, AKN206CVC & C Transportation Inc · Benton, LAN206DKFly Waveboard Inc Trustee · Wilmington, DEN206DMBushwood Air LLC · Coeur D Alene, IDN206DTSchons Jeffrey · Pacific City, ORN206DVBowman And Dehn Enterprises Inc · Georgetown, DEN206DWAlaskan Start Aviation LLC · Midland, TXN206DYMorgan Farms LLC · Nyssa, ORN206EAAbrams Edward L · Roxbury, CTN206EEHastings Ranch Vineyard · Paso Robles, CAN206EKKoch & Koch Inc · Grass Valley, CAN206EMHoopes Turf Farm Inc · Ulysses, PAN206ETTorgerson Eric L · Ethridge, MTN206GSmith Air LLC · Cascade, IDN206GAPrijatel Thomas J · Cordova, AKN206GESheldon Graham · Bellevue, WAN206GVSawtooth Flying Service · Mccall, IDN206HMilestone Aviation LLC · Vail, CON206HDBarry Adventure Travel Inc · Pagosa Springs, CON206HGSeecat LLC · Palo Alto, CAN206HHSawtooth Flying Service Inc · Mccall, IDN206HJRauch Peter · Austin, TXN206HMDma Aviation Services LLC · Wilmington, DEN206JWMarley William Jay Jr · Homer, AKN206KDStubblefield Fancho F Jr Trustee · Amity, ORN206LWestern Air Pilots LLC · Mountain Home, ARN206LEFort Worth And Western Air Express LLC · Southlake, TXN206LGHotel Kilo Aviation LLC · Anchorage, AKN206LLMoondog Motorsports LLC · Missoula, MTN206MBAircraft Trustee Services Inc Trustee · Dover, DEN206MDAuction Aviation Inc · Boulder City, NVN206MESouthwest Erosion Control · Mckinney, TXN206MFMission Aviation Fellowship · Nampa, IDN206MNMartin Nelson & Co Inc · Seattle, WAN206MTBlue Spruce LLC · Bigfork, MTN206MVBrownlie Michael V · Chandler, AZN206MWZaludy Aviation LLC · Paynesville, MNN206MZKtbr Holdings LLC · Statesboro, GAN206PDRockwell Collins Inc · Cedar Rapids, IAN206PFPatriot Fuels Inc · Alexander, NDN206PJIllingworth Paul John · Georgetown, TXN206PMTunnel Aviation LLC · Tunnel Hill, GA
Back to AD 2012-10-52