AD 2026-17-10
Registered aircraft · 19,185
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:2026-17-10')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2026-17-10')
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:2026-17-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2026-17-10') 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.
N1002HSmith Michael S · Anchorage, AKN1004DGiezen Jurgen J · Fairfax, VAN1004TI1 Aviation LLC · Ronkonkoma, NYN1007UKallam Jerry · Palmer, AKN1008EEdwards Gregory S · Guthrie, OKN1008WRay Jonas · Palmer, AKN100AESale Reported · Spencer, NESale reported, pending cancellationN100BVHoward Keith · Fayetteville, NCN100DDCook Allen J · Aurora, CON100EEConcho Aviation LLC · Sterling City, TXN100HX14 Aero Spaces LLC · Wilmington, DEN100JGClub Cherokee Inc · Crystal, MNN100JVKremers Gary · Zeeland, MIN100LGFlyd Pipers Inc · Dyer, INN100LWN100lw LLC · Hickory, NCN100PBDoobie Air LLC · Wilmington, DEN100QBShutt Ryan T · Eden, NYN100UKFurlow Paul S · Annapolis, MDN100XXAskew Stell Blake III · Durham, NCN1010EIndian Aire LLC · Water Mill, NYN1010RKaneair LLC · Hayes, VAN1011TPedersen Michael · Bakersfield, CAN1012GForwalt Lucas A · Chesapeake, VAN1012YNelson Susan P · Kirkland, WAN1014BClark Joseph C · Avondale, PAN1014EMeade Lance M · Stinson Beach, CAN1014QLawler Thomas O · Lava Hot Springs, IDN1014TInternational Air Services Inc Trustee · Carson City, NVN1016NDrln Aviation LLC · Charlotte, NCN10178Kings Engineering Fellowship · Orange City, IAN1018HGulf Air Group Inc · Crestview, FLN1019VQualitair LLC Trustee · MichelstadtN101AFState Of Louisiana · Baton Rouge, LAN101ATZrelak Patrick DBA · Apple Valley, CAN101BVMundwiler David · Hemet, CAN101DHLarson David R · Boerne, TXN101DRShaheen Louis · Austin, TXN101DWInternational Air Services Inc Trustee · Carson City, NVN101GD101 Gd Corp · Miami, FLN101HHElmhurst Holdings LLC · East Rochester, NYN101NEDarby Flying Corp · Homestead, FLN101NWVortex Aircrafts Inc · Port Saint Lucie, FLN101SUSouthern Utah University · Cedar City, UTN101SXCattrell Jeff S · Church Hill, TNN101TVSky Helicopters Inc · Garland, TXN101VBRegistered aircraftN101VRDunn Thomas A · Fairhope, ALN101WCole-Tac LLC · Rapid City, SDN101WGGard Aviation LLC · Elkhart, IAN101YTJagt Terrence L · Crestline, CA
Back to AD 2026-17-10