AD 75-12-08
Registered aircraft · 949
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-12-08')
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-12-08')
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-12-08') 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-12-08') 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.
N104DLMartin Harold J · Hobbs, NMN10589Belgarde Ashley T · Fitchburg, WIN1059BDimmitt William C · Los Lunas, NMN1059SMoughan Gavin P · Albuquerque, NMN1059YZielinski Gary R · Gainesville, GAN1059ZGauthier Daniel R · Waterford, MIN1061AAmlong Jeanine M · Rio Rancho, NMN1061GWilson Daniel E · Tucson, AZN1061HBristol David W · Sautee Nacoochee, GAN1061SDepew Michael P · Nashua, NHN10623Ripsnorter LLC · Washington, INN1062GCanaday Bruce S · Woodstock, ILN1062KJoslin James E · Emily, MNN1062QBelgarde Sonja K · Sun Prairie, WIN1062SDepew Michael P · Nashua, NHN1062VMagee Aviation Services LLC · Rochester, NYN1062YBristol David W · Sautee, GAN10631Beck Richard S · Acworth, GAN10634Olive Jonathan Scott · Albuquerque, NMN10636What A Wind LLC · Mattawan, MIN1063SDimmitt William C · Los Lunas, NMN1063TCanaday Bruce S · Woodstock, ILN1063VFear Katrina Mj · Rio Rancho, NMN1063YBeard Jeffrey M · Sedona, AZN1096FBalloons Over Bloomington LLC · Bloomington, INN10WLBlue Ridge Hot Air Balloons LLC · Front Royal, VAN110AAMaguire Douglas Gary · Allenspark, CON111ZBAeronautical Solutions LLC · Taos, NMN116FSLowenstein Albert L · Albuquerque, NMN1206WKenyo R Eugene · Hudson, OHN1242FRodrigue James N · Lewiston, MEN13CCWagner Cameron B · Casper, WYN14CCCloud 9 Enterprises Inc · Rochester, MNN14PDBucket List Adventures LLC · Albuquerque, NMN1500XM Deeney Enterprises LLC · Monticello, FLN15017Runge David B · Grand Prairie, TXN1501BTrieber Steven M · Eastport, MEN1502HCoastal Balloons LLC · Norfolk, VAN1502TFights Mitchell · Kellyville, OKN15030Pennebacker David C · Benton, PAN15049Butler William M · Alamogordo, NMN1505HHart Randall A · Meridian, IDN15072Buch Zachary R · Nevada, OHN1507NWalker Luke A · Riverton, WYN1508WBaker Carmen W · Lexington, NCN15095Howes Skip · Colorado Springs, CON1509URitland Christopher M · Quechee, VTN15103Jagust William M · Troy, MON1510CPortland Rose Balloons LLC · Wilsonville, ORN15111Civil Air Patrol · Maxwell Afb, AL
Back to AD 75-12-08