AD 93-16-13
Registered aircraft · 868
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:93-16-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:93-16-13')
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:93-16-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:93-16-13') 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.
N27CRBrown Charles S Jr · Mount Washington, KYN27TMPerkins Michael D · Las Vegas, NVN2801ASmith Jim D · Lovington, NMN2803GDigiovanni Ronald T · Milford, NJN2803NAlbuquerue Balloon Center Inc · Albuquerque, NMN2804UH I Flight Inc · Lexington, KYN2805NGriffin Daniel J · Ft Collins, CON2805YSchuler Gerald E · Reno, NVN2806DVogt Gerald J · Erie, PAN28071Korn Bruce · Mindoro, WIN2807NJbc Aeronauts LLC · Colorado Springs, CON2808CBush Stewart D · Rio Rancho, NMN2810DIrvin Ronald L · Derby, KSN28120Carrigan Meron Robert · Murrieta, CAN2815BIcxing LLC · Prineville, ORN281MSWiederkehr Matt H · Centerville, MNN28282Reichhart Richard B · Honeoye Falls, NYN28366Krieg Fred W · Independence, ORN2847NPost William S · Custer, WAN2854AHodges Eric C · Rio Rancho, NMN2864EBallooning Adventures Of Colorado LLC · Denver, CON28724Zemlachenko Michael · Cape Canaveral, FLN2876DJutras Joan C · Loxahatchee, FLN29236Atwill John R IV · Vancouver, WAFirst renewal noticeN29417Sommers Christopher Alan · Slatington, PAN2941KWilliams Scott M · Gales Ferry, CTN3009RWagoner David F Jr · Pasadena, MDN3015RDicocco Anthony Jr · Pennington, NJN3081RLamontagne Seth A · Pittsfield, NHN30TRSouthern Arizona Balloon Exc Inc · Tucson, AZN313LTLetherer Steven C · Farwell, MIN31492Frankie John · Bellport, NYN322PCPlains Capital Corp · Lubbock, TXN3303XRoss Fred · Hollywood, FLN35541Chando Morghan E · Albuquerque, NMN3554DDrake Richard R · Radcliffe, IAFirst renewal noticeN3556BKramer David A · Fort Edward, NYN3557CMarketing Services Inc Of Pueblo · Colorado Springs, COFirst renewal noticeN35631Nemesis Balloon Team LLC · Helena, MTN3565GLucas Robert · Decatur, ALN3566KNewberg Edgar T · Hector, MNN35693Hatfield Jason G · Gardnerville, NVN35694Oswald Donald W · Palmdale, CAN3570GBradley Kenneth P · Evans, CON3575GSproul Keith A · North Brunswick, NJN35773Tobin Joshua Lee · Belen, NMN3578DMccombs Audrey L · Albuquerque, NMN3578NOdom David R · Gainesville, GAN3580LGarrett Terry S · Indianola, IAN3581DBrown Charles S Jr · Mount Washington, KY
Back to AD 93-16-13