AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.
N78358All American Aviation LLC · Fort Worth, TXN78359Burns Stanley R · Flagler, CON7835NOrrill Bill · Godfrey, ILN7835YRegistration Pending · Lewes, DERegistration pendingN78367Dardis Barry J · Great Falls, MTN7836NMelancon Scottie J · Baton Rouge, LAN7836PKearney Kory · Papillion, NEN78371Lillace Kevan · Shelby, MTN78375Bozeman Leasing Inc · Bozeman, MTN78379Bottrell John E II · Yukon, OKN7837GGlass Jay Thomas · El Dorado, ARN7837HCounsell Michael J · Moses Lake, WAN7837MDiamond B Farm Inc · Gamaliel, KYN7837PMobbd LLC · Vero Beach, FLN7837WHock Matthew G · Culbertson, NEN78385Amf Aviation LLC · Dallas, GAN78388Fortner Weston · Fort Payne, ALN7838NWright David P Jr · Chandler, AZN78395Fgds LLC · Louisville, KYN7839DMartin David · Jackson, GAN7839GGerty Air LLC · Sidney, MEN7839NHaddle Eddie J · Lindon, UTN7839VHafter Mark S · Cincinnati, OHN783AJApple Ronald L · Fort Myers, FLN783BWestside Air Inc Renton · Renton, WAN783DGJeffery & Weiss Holdings LLC · Long Beach, CAN783FMFmfa Inc · Wilmington, DEN783LAN783la LLC · Philadelphia, PAN783LKPullis Troy K · Hutchinson, MNN783LULiberty University School Of Aeronautics · Lynchburg, VAN783NDVertol Systems Company Inc · Destin, FLN783RVAvexp1 LLC · Fayetteville, GAN783SCWeiblen Glenn P · Castroville, TXN783SHKmc Aircraft Leasing LLC · Spanish Fork, UTN783VVanstory Randy · New Braunfels, TXN783WWThomas Michael D · Centralia, WAN78408On The Fly Aero LLC · Ocean City, NJN7840DDavis Steven T · Colleyville, TXN7840FLederach David B · Bethlehem, PAN7840NBiby Steven R · Churchs Ferry, NDN7840VShedd John G · Hopewell, NJN7840WTomic Milos · Westminster, CON7840XShaw Christopher S · Porterville, CAFirst renewal noticeN7840YArno Philip A · Clarence Center, NYN7841VKohler Donald L W · Hernando, FLN7841WBasin Flyers LLC · Klamath Falls, ORN78424Acapulco Flying Club LLC · New Brighton, MNN78428Cypher Anne K · The Dalles, ORN78429Doughty Robert M · Earlville, ILN7842BLowe David M · Sacramento, KY
Back to AD 87-10-06 R1