AD 59-16-01
Registered aircraft · 58
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:59-16-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:59-16-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:59-16-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:59-16-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.
N10RTBarbers Point Flight School LLC · Kapolei, HIN1169Downes Pamela · Chino Hills, CAN1187DCordero Miguel · Hollywood, FLN11LWilkins Daryl J · Linden, CAN124JPCommemorative Air Force · Dallas, TXN138KSouth Bay Aviation Inc · Torrance, CAN159KIsland Hopper Air LLC · Ponte Vedra Beach, FLN19KDFlabob Airport LLC · Riverside, CAN264RWDeneve Antoinette · De Kalb, TXN2657BHughes Coby D · Collinsville, OKN2665BSteria Kermit J · Monahans, TXN2700BBackcountry Commander LLC · Wray, CON2732BWolff Martin · Houston, TXN2750BRodrigues Steven W · Manteca, CAN2755LMerxbauer Terry E · La Pine, ORN2782BAbbing Frits G H · Crescent City, FLN2788BK&L Agri Farms Inc · Adams, NEN289GRAerocomm LLC · Kalispell, MTN30UAmerican Airpower Heritage Flying Museum Inc · Dallas, TXN312ECAmy Johan J · Coral Springs, FLN3341Sale Reported · La Plata, NMSale reported, pending cancellationN3836CAdvanced Airways Inc · Loxahatchee, FLN3846CCrowder Eston W · Dade City, FLN411VVScott William H · Mount Pleasant, SCN4131BPadgett Mfg Inc · Bradenton, FLN4136BWright Michael E · Hurricane, UTN4142BKnutson Wayne R · Tioga, NDN4179BMitchell Matthew K · Cushing, OKN4189BKruger Thomas H · Hoquiam, WAN424RKTerry Ryan · White Lake, MIN4278SChagnot Catherine J · Athens, OHN4618ESale Reported · El Paso, TXSale reportedN503RTPew Don E · Queen Creek, AZN520RNAeronorth LLC · Ann Arbor, MIN561KEMaglaughlin Ronald D · Udall, KSN56FRWoods Mark T · Fernandina Beach, FLN58GSzarek Evelyn Personal Representative · Fairbanks, AKN590WAba Contractors Inc · Arcadia, OKN6217DSmithey Larry M · Wake Forest, NCN6222DRobertson C A · Phoenix, AZN623FSMorse Edward K Jr · Wasilla, AKN6267BRosario Angela · San Juan, PRN6277BCerra Eduardo · Miami, FLN6278DSale Reported · Oklahoma City, OKSale reportedN6290BCaribbean Shuttle LLC · Aventura, FLN677JRRoach James M · West Bountiful, UTN68113Gogoplex LLC · Wilmington, DEN6819QWalker Gilbert R · Brentwood, TNN6883SWebb Ronald G · Dickson, TNN70DMartin Ernest · Sandpoint, ID
Back to AD 59-16-01