AD 2026-22-13
Registered aircraft · 47,600
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-22-13')
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-22-13')
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-22-13') 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-22-13') 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.
N100XXAskew Stell Blake III · Durham, NCN100YAShelton Joel T · Grass Valley, CAN1010MSimpson Kendal L · Port Orange, FLN1010QBurklund Joel H · Minneapolis, MNN1010RKaneair LLC · Hayes, VAN1011NBlue Skies Aircraft LLC · Zephyrhills, FLN1011TPedersen Michael · Bakersfield, CAN1011ZChiappe Richard S · Estes Park, CON1012ASimmons Michael T · Carolina Beach, NCN1012GForwalt Lucas A · Chesapeake, VAN1012YNelson Susan P · Kirkland, WAN1013EFouts Chester L · Turner, MTN1014BClark Joseph C · Avondale, PAN1014EMeade Lance M · Stinson Beach, CAN1014FPeppard Kenneth W · Dumfries, VAN1014QLawler Thomas O · Lava Hot Springs, IDN1014TInternational Air Services Inc Trustee · Carson City, NVN1014ZMorse Spencer W · Colorado Springs, CON1016FFly Cadillac LLC · Tustin, MIN1016NDrln Aviation LLC · Charlotte, NCN1017EButtanda Denise · Winchester, VAN1017PZeivogel Jeanine · Gulf Shores, ALN10183Excelsior Aviation 2 LLC · Lewes, DEN1018HGulf Air Group Inc · Crestview, FLN1019FFly By Aviation LLC · Sun Valley, CAN101AFState Of Louisiana · Baton Rouge, LAN101ATZrelak Patrick DBA · Apple Valley, CAN101BTMartin John D · Billings, MTN101BVMundwiler David · Hemet, CAN101DDa Plane LLC · Longmont, CON101DFFrench James H · College Park, MDN101DHLarson David R · Boerne, TXN101DRShaheen Louis · Austin, TXN101DWInternational Air Services Inc Trustee · Carson City, NVN101EBKinneen Simon N · Nome, AKN101FDLakala Aviation Inc · Vicksburg, MIN101GEInternational Air Services Inc Trustee · Carson City, NVN101GNGreat Northern Aircraft Inc · Griffith, INN101HHElmhurst Holdings LLC · East Rochester, NYFirst renewal noticeN101JDresden Leasing LLC · Sheridan, WYN101KRVlach Ronald G · Fremont, NEN101KSWright Kenneth D · Benton, ARN101KWWiseman Ken L DBA · Calhoun, GAN101LGSmart Robbie A · Wasilla, AKN101LJGrenier Garret P · Anchorage, AKN101MFUsda Forest Service Fepp · Trenton, NJN101MSKoenig William J · Benedict, MDN101NNavionaire Inc · Miami, FLN101NEDarby Flying Corp · Homestead, FLN101NL1st American Aviation Inc · North Miami, FL
Back to AD 2026-22-13