AD 86-10-11 R1
Registered aircraft · 374
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:86-10-11-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-10-11-R1')
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:86-10-11-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-10-11-R1') 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.
N40192Bishop C J · Englewood, CON4024GGriffin Daniel J · Ft Collins, CON40253Registration Pending · Pagosa Springs, CORegistration pendingN4026LJohnson Meridian S N · Santa Fe, NMN4042SKimmich Russ S · Coronado, CAN40515Ace Aviation Adventures Inc · Ann Arbor, MIN40719Dougherty Donald A · Colorado Springs, CON4079KC A F Inc · Lakeland, MNN4082ZUhlir Tammy Lea · Maplewood, MNN4089UCecil Thomas O · Jeffersonville, INN41000Horton Eric D · Fenton, 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, AZN4194EWillco 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, NYN4226FBoyd Gary G · Albuquerque, NMN4246AHart 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, AZN50416Post Balloon Club Inc · Battle Creek, MI
Back to AD 86-10-11 R1