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.
N40719Dougherty Donald A · Colorado Springs, CON4075DYoung Carl E · De Witt, IAN4079KC A F Inc · Lakeland, MNN4082ZUhlir Tammy Lea · Maplewood, MNN4089UCecil Thomas O · Jeffersonville, INN4093QHackett Myia M · Albuquerque, NMN40976Kuller Timothy D · Mesa, AZN41000Horton Eric D · Fenton, MIN411AMMastis Raminta I · West Bloomfield, MIN4183GBalloon Quest Inc · Fenton, MIN41876Reichhart Richard B · Honeoyefalls, NYN41908Bradley Kenneth P · Evans, CON4192MWhelan Farms Airport LLC · Bethlehem, CTN4193ABorchert James E · Bloomington, MNN4193HDigiovanni Ronald · Milford, NJN4193PNilz Boby J · Tucson, AZFirst renewal noticeN4194CEnfield Douglas T · Elizabeth, CON4194EWillco Services LLC · Lavonia, GAN4194KZuniga George · House Springs, MON4195CGarcia Jerry W · Albuquerque, NMN4196BCostello Paul E · Topeka, KSN4197NStangeland David · Cedar Falls, IAN41982White Shannon W · Loveland, CON4198CVill Joseph E Jr · Purcellville, VAN4204NHitron John W · Louisville, KYN4209CStumpf Paul S · Andover, VTN4224UBarber Russell · Hudson, NYFirst renewal noticeN4226FBoyd Gary G · Albuquerque, NMN422GDStuart Erica Nicole · Rincon, GAN4246AHart Lewis W · Rexburg, IDN4246SFlight Expo Inc · Princeton, MNN42702Digiovanni Ronald · Milford, NJN4270ARoss Fred · Hollywood, FLN4270ZRieck Brian M · Junction, TXN4271ASommers Christopher A · Slatington, PAN4271RGwin Corey · Hot Springs, SDN42720Elliott Thomas J III · Lafayette, CAN42731Balloonatics And Aeronuts LLC · Belvidere, NJN4274CWiederkehr Balloons International · Hugo, MNN4274DBechtold Larry E · Apple Valley, CAN4392USommers Christopher A · Slatington, PAN4394EAugust Joe A · Newport Beach, CAN4394XGarner Kenneth W · Decatur, ALN4395LWhite Shannon N · Loveland, CON4397VWinchester William E · Jonesboro, ARN4398VBagwell Michael L · Hoschton, GAN4401YMajestic Adventures Inc · South Lyon, MIN4401ZOswald Donald W · Palmdale, CAN4402ENilz Patrick Shawn · Marana, AZN46KSCarlton Robert D · Polk City, FL
Back to AD 93-16-13