AD 46-17-01
Registered aircraft · 107
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:46-17-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:46-17-01')
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:46-17-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:46-17-01') 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.
N57418Rushing Christopher P · Van Nuys, CAN57493Alpha Air LLC · Sparks, NVN5WSShelton Greg N Trustee · Collinsville, OKN601JFAt-6c LLC · Wilmington, DEN60380Buffalo Aviation LLC · Monette, ARN604RTelling Frederick W · Port Orange, FLN61MHJasmine Inc · Lewes, DEFirst renewal noticeN620AJFancy Sparks Aviation LLC · Bear, DEN623DCHenshaw Richard L Jr · N Prince George, VAN648DBW&W Aircraft Leasing LLC · Claremore, OKN6558DWestern Warbirds LLC · Prescott, AZN6617XBurns Charles R · Huntsville, ALN6637CBlack Pearl Snj LLC · Springville, NYN684RCCremante LLC · Carson City, NVN696REAircraft Guaranty Corp Trustee · Oklahoma City, OKN697DST-6 LLC · Manassas, VAN7033CClifford Michael P · Paris, TXN7054RBrown Aviation LLC · Warrenton, VAN7055HMiddleton Kim I · Long Beach, CAN7055KNelson Richard · Tucson, AZN7061CDo Whut Inc · Wilmington, DEN7078CHawks Zero Q 3 LLC · Sonoma, CAN7177Kubecka Jill A · Edna, TXN7292Kubecka Jill A · Edna, TXN7293YMoore Murray H · Twain Harte, CAN7413CPierucci Crown Lori D · San Luis Obispo, CAN7421CBritton Scott M · Fairview, TXN7462C5gus Inc · Tallulah, LAN7471SLonestar 6 LLC · Warwick, RIN7638CLindemann Flying Service LLC · Valley City, NDN7639Kubecka Jill A · Edna, TXN7649SSimmons Mark A DBA · Pawcatuck, CTN7653AKubecka Jill A · Edna, TXN7678ZSimply Living LLC · Fort Myers, FLN7693ZAngelici Arnold Anthony Jr Trustee · Peachtree City, GAN77TXAir Cover Academy LLC · Frankford, MON78RNDawson Jamie Stewart · Celina, TXN7991CFernalld Richard C · Yelm, WAN8021RN8021r LLC · Scottsdale, AZN817NPWar Relics LLC · Jackson, MSN832AJHochhaus Andrew · Norfolk, VAN867DLLinville Douglas A II · Suwanee, GAN88RTAnderson Mike DBA · Muskogee, OKN8BPKempf Douglas A · Crawford, CON90629Kelley Richard E · Spring Branch, TXN9235ZJohnson John J · Wasilla, AKN92375Fisher Air LLC · Cardington, OHN94444American Heritage Aviation Inc · Peachtree City, GAFirst renewal noticeN9523CFarber Paul S · Albertson, NYN9525CCondor Squadron Officers & Airmens Assoc Inc · Van Nuys, CA
Back to AD 46-17-01