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.
N2468YGv Air Inc · Medford, ORN2469H69h LLC · Ocean City, MDN246APT & N Holdings LLC · Tyler, TXN246ECKnight Air LLC · Wausau, WIN246MEWyoming Seaplanes LLC · Alpine, WYN2477XLecce Aviation LLC · Williamsport, PAN2478AEnnair LLC · Kalispell, MTN247CBDream Machine Leasing LLC · Glenbrook, NVN2480SAircraft Guaranty Corp Trustee · Oklahoma City, OKN248HSLitchfield Lantz · Las Vegas, NVN248RCMckinley I Blake Jr · Spokane Valley, WAFirst renewal noticeN248RRWalter Air Co LLC · Oakdale, CAN2492SSierra Hotel Aircraft LLC · Wilmington, DEN2498SKatz Michael R Trustee · Merritt Island, FLN249FMValiair Limited Co Trustee · Casper, WYN249TARkl Consulting LLC · Keizer, ORN24CHDagostini Robert A · Mount Aukum, CAN24GLTextron Aviation Inc · Wichita, KSN24HSSandoval Ernest D · Cave Creek, AZN24NHBeyer Roger · Paw Paw, MIN2501SGonzales Gerald · Dallas, TXN2508SErnst Don A · San Luis Obispo, CAN250MELake Superior Aviation Llp · Duluth, MNN251DPDisa Air LLC · Laredo, TXN25206Megwetch Aviation LLC · Auburn, MEN2525XTolbert Mark A · Canandaigua, NYN252CPCivil Air Patrol · Maxwell Afb, ALN252LTAerownership North American Services Inc Trustee · Wilmington, DEN252SWSymns Robert A · Aguila, AZN2538SBarbo Walter A · Aurora, CON253JGFly Good Land Gooder Holdings LLC · Tomah, WIN254CSVallencourt Construction Co Inc · Green Cove Springs, FLN255TMGiles Durham K · Davis, CAN256MBMunobraca LLC · Mcallen, TXN2580SArizona Production Machinery & Supply · Casa Grande, AZN2588TAircraft Trustee Services Inc Trustee · Dover, DEN259BWPinal County Sheriffs Office · Florence, AZN259PHPbh Air Adventures LLC · Cedar City, UTN25GPAir Data Solutions LLC · Natchitoches, LAN25PYAir4je LLC · West Chester, PAN260RDAircraft Trustee Services Inc Trustee · Dover, DEN2616SMontana Alpha Omega Ranch LLC · Miles City, MTN261CPCivil Air Patrol · Maxwell Afb, ALN2626ZJf Aviation LLC · Minot, NDN262CACompass Aviation Inc · Shelby, NCN262SHTextron Aviation Inc · Wichita, KSN2638ULindsey Aviation Services · Haslet, TXN263MECommercial Aerial Images Inc · Costa Mesa, CAN263RCRichland County Sheriffs Department · Columbia, SCN2642SReich Stephen Barry · Kentfield, CA
Back to AD 2012-10-52