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.
N92PKRun Through Aviation LLC · Roanoke, VAN92PRDtc Cirrus LLC · Kalispell, MTN92SXApplied Process Logic Inc · San Luis Obispo, CAN92WFNpp Aviation I LLC · Teton Village, WYN92WH322ee Aviation LLC · Union, KYN92WTCanyon Capital Assets LLC · Newark, DEN9307YRader Drew · Avon, CON9309YYecny Alan K · San Luis Obispo, CAN930DBKropp Christian Trustee · Azle, TXN930DGBieker James M · Eatonville, WAN930KHDirt Aviation LLC · Rome, GAN930MRJbk Aviation LLC · Bradfordwoods, PAN930SEStevens Neil Larry · Bingham Lake, MNN930SMMask Holdings LLC · Holland, MIN93128High Plains Aero Consulting Inc · Pampa, TXN93129Klca Inc · Warsaw, INN93186Bates Byron B · Ethel, WAN931CTCub Aviation LLC · Wilmington, DEN931DRTls Aviation LLC · Kalispell, MTN931PCJac Tay LLC · Saint Louis, MON9322TG&G Airplane LLC · Mobile, ALN93262Land Office LLC · Burlington, CON93274Wltf LLC · Caldwell, IDN93285Corrie Brent · Vero Beach, FLN93295Gates Steven · Midlothian, TXN932TARadioactive LLC · Ft Wright, KYN9330TCrusader 303 LLC · Eugene, ORN93344Cardinal Headings Ltd · Wilmington, DEN93350Rowe M D Trustee · Bozeman, MTN93354Utah County Sheriff · Spanish Fork, UTN93362Bouvier Ellis C · Prineville, ORN93380Stahla Robert E Trustee · Grand Island, NEN9338ZBarr Air Patrol LLC · Mesquite, TXN933CDCook Larry · Midland, TXN933DHBonanza Associates Llp · Colorado Springs, CON933WPMed Shuttle LLC · Jackson, TNN934CRReygar Investments LLC · Brownsville, TXN934DRCtrg Aviation Holdings 2 LLC · Lakeway, TXN934PCBennell Ltd LLC · Naples, FLN934SYAviation Trust Company LLC Trustee · Oklahoma City, OKN934VFinke Wailes · Charleston, MSN9353YKovax Aviation LLC · Youngstown, OHN9356YParsons Bruce W Trustee · Costa Mesa, CAN935CDRussell Ronald W · Auburn, ALN935DRDd LLC · Wilmington, DEN935SRSmaistrla Jeffrey L · Montgomery, TXN935TSLvta Holdings LLC · Dundee, OHN9369YBk Aviation Services LLC · Yorba Linda, CAN936BCChase Brandon M · Granbury, TXN936CMContinental Aerospace Technologies Inc · Mobile, AL
Back to AD 2012-10-13