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.
N2210HDenicola Samuel W · Greenwell Springs, LAN2210VCrabtree Elliott S · Topeka, KSN2211PPurvis George W · Tallahassee, FLN2212CAirborne Adventures Ballooning Inc · Munnsville, NYN2223HSwanson Richard · Sandia Park, NMN2266HDavis John C IV · Evergreen, CON2380HDekoevend Enterprises Inc · Fort Garland, CON238ZASuskin Dan · Atlanta, GAN2428ZBechtold Larry E · Apple Valley, CAN242MSScott Michael R · Rio Rancho, NMN2502KClark Roger D · Greer, SCN25048Carnegie Ronald S Jr · Williamsburg, VAN2517TJames Steve W · Savannah, MON25214Gower Marshall L · Town Creek, ALN25250Baldwin Thomas R · Asbury, NJN25272Cleary Robert A · Ironton, OHN25303Christopher Chris A · Morgantown, WVN25326Blair Paul · Portales, NMN2538KKeenan Thomas · Las Vegas, NVFirst renewal noticeN2539JEasy Breezes Inc · Pittstown, NJN2542JBartsch Thomas A · Panguitch, UTN2544USutter Denis M · Hallsville, MON25510Blair John C · Bridgeton, NJN25529Ehlinger Robert E · Highlands Ranch, CON25536Dekoevend Enterprises · Fort Garland, CON2553FRaya Shawn M · Highland, MIN2553HBrakeman David M · Decatur, ALN2553KV1 Rotate LLC · Statesville, NCN2554QLucas Claire M · Vallejo, CAN25556Ingraham Richard · Littleton, CON2556EStarr William K · Buckeye, AZN25577Gallant Michael T · Columbus, INN2557KLta Partners LLC · Lindon, UTN25588Cunningham Brian C · Thornton, CON25592Mcglade Zane Kg · Woodward, IAN25616Irwin Patrick S · Lovelock, NVN25619Mabee Bryant J · Vestal, NYN2563HAeronautical Solutions LLC · Taos, NMN2563QAerostat Promotions LLC · East Granby, CTN2563YGransbury Theodore C · Plainfield, INN25651Hyde Daniel C · Albuquerque, NMN25654Sewell Robert M · Reno, NVN25655Fitch Matthew F · Albuquerque, NMN25657Olmstead Robert C II · East Randolph, VTN2565ZHartshorn Sharon · Amarillo, TXN25664Thomas George E · Hallsville, MON2566KBowman James A · Oklahoma City, OKN25672Jennings Jay A · San Ramon, CAN25682Studebaker Charles C · Albuquerque, NMN2568KI-Review Corp · Galesburg, IL
Back to AD 75-12-08