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.
N333HRWilson Alan E Trustee · Erie, CON333LB333lb LLC · Fort Worth, TXN333PSDoran Jeffrey T · Westerville, OHN335JWN335jw LLC · Hilton Head Island, SCN335SFRamont Ronald G Jr Trustee · Modesto, CAN338SAGonzalez Jesse · Colorado Springs, CON338WSWinsors Wings LLC · Rogersville, MON33AGSory Bailey B IV · Bozeman, MTN33BBHendricks Timothy J · Telluride, CON33SQJohnston H Kenneth II · Wheatland, WYN33UT402wd Holdings LLC · Corpus Christi, TXN340CSTextron Aviation Inc · Wichita, KSN3422Hergenrather Michael · Spring, TXN3422LAwsm Inc · Grand Canyon, AZN342CSTextron Aviation Inc · Wichita, KSN3432FBierschwale Land Co LLC · Mason, TXN3441LBarlow Dwight D · Monte Vista, CON3447LHulst Damon M · Santa Barbara, CAN344AJQualitair LLC Trustee · MichelstadtN345DPBack Country Hacks LLC · Olalla, WAN3463LLrh Equipment LLC · Pendleton, ORN346CKCk Contracting Inc · Kings Mountain, NCN346JHRobertson Timothy A · Lewistown, MTN346RNSchroll Charles E · Tucson, AZN34BTWilliams Charles R · Wadsworth, OHN34KBReilly Donald H · Micco, FLN34PLMoonglow Aviation LLC · Toledo, OHN35014Trionz LLC · Artesia, NMN3506HHorn Marcia L · Erie, CON3506YCascade Commodities LLC · Saint Paul, MNN3510PFlying Gilley Ranch LLC · Tryon, OKN3510TTextron Aviation Inc · Wichita, KSN351JAHutchins William · Kennesaw, GAN3530CBig Horn Tire Inc · Gillette, WYN3532YEdwin C Poss Inc · Clayton, GAN35343Oconner Thomas Anthony · White Salmon, WAN3536MBj Air Northwest LLC · Quincy, WAN3538RUS Department Of Homeland Security · Washington, DCN3542ZBlack Duck Enterprises LLC · West Creek, NJN35438Kern County Sheriffs Department · Bakersfield, CAN3543BUS Department Of Homeland Security · Washington, DCN35440Norwood Jon D · Damon, TXN35443Registered aircraftN3547TAircraft Guaranty Corp Trustee · Oklahoma City, OKN354BSStevenson Bill · Sunrise Beach, TXN355CWLevare Aviation Inc · Hillsborough, NJN355SRMoonglow Aviation LLC · Dover, DEN355YPlussa Mark George · Clermont, FLN356SFSheehan Aviation Family Enterprises LLC · Boise, IDN357DRImsar LLC · Springville, UT
Back to AD 2012-10-52