AD 75-04-12
Registered aircraft · 402
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:75-04-12')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-04-12')
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:75-04-12') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-04-12') 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.
N159AFMorter Roger P · Hermiston, ORN15MMMeyers David L · Palmer, AKN160BCPridmore Reginald C · Laughlin, NVN162BCRegistration Pending · Tampa, FLRegistration pendingN165ACBrian & Karen Snodgrass Farms LLC · Seminole, TXN165BCMckinney William C · Whitefish, MTN167BWMartin Jennifer · Palm Desert, CAN168BCWildlife Air LLC · Dubois, WYN178BCAllen Lisa M · Melba, IDN178TTLockwood Kurt G · Fairbanks, AKN179BCDenmark Ag · Winters, CAN180CGBailey Bendrix · Rochester, MAN180LARonsman Harry M · Talkeetna, AKN181TMEichhorn Scott William · Searcy, ARN186ACHartman James R Trustee · Everett, WAN188BCWaldron Elijah L · Murfreesboro, TNN188RSVardaman Charles · Little Rock, ARN189BCEph LLC · Eagle, IDN193ACStearman Aviation Inc · Crawford, CON193GFFlattum Steven · Hampshire, ILN194BCAircraft Investments LLC · Ketchum, IDN196THHiers Timothy F · Barney, GAN197BCSeruset Jeffrey G · Butler, PAN198BCOconnell Tiffany LLC · Newbury, NHN198QQuale Scott · New Town, NDN19CKBuckmeier Arlan M · Fairbanks, AKN19CWRussmann Nick S · Merit, TXN215BCMetzler Alan J · Reedsville, PAN216BCBell Wendell D · Littlerock, WAN21PZEarl'S Spray Service Inc · Breckenridge, MIN221PMHester Thomas F · Boulder, UTN225THMariner John M · Houston, TXN22SXChase Jack L · Buxton, MEN231PMBernard Raymond C · Melba, IDN233SFSale Reported · Wakarusa, INSale reportedN239LLLloyd Land Plane V LLC · Brighton, CON23BDCox Mike Trustee · Casper, WYN240SSStroup Robert L · New River, AZN242BCElemental Aviation Lc · Wichita, KSN247BCPlane Nutz LLC · Sugar City, IDN249SFCasarez David W · Carmel Valley, CAN24SDHall Mike · Houston, TXN2510ZCherry Hill Aviation Inc · Freetown, INN251WCThyssen Patrick L · Conroe, TXN2547ZLecompte Francesca · Lancaster, MAN2590ZWollaston Dean E · Hazel Green, WIN25GFNorth Dakota Game And Fish Dept · Bismarck, NDN2667ZHite Loren E · Fairbanks, AKN2682ZEmslie Donis A · West Lafayette, OHN2693ZCoen Brady · Wiley, CO
Back to AD 75-04-12