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.
N108WMMoran William J · Media, PAN108YGoduto Aeronautics LLC · Monroe, CTN1090ECrouse John A · Sterling, AKN1090FIsley Jason T · Sand Springs, OKN1091MSwaz Aviation LLC · Mesa, AZN1092TH4s Aviation LLC · Longview, TXN1093Museum Of Flight Foundation · Seattle, WAFirst renewal noticeN1093XRoseville Aviation LLC · Roxboro, NCN1094FG&M Aircraft Inc · Wheat Ridge, CON1094UBrajnikoff Edward C · San Francisco, CAN1095EIndependent Dusting Service Inc · El Campo, TXN1095UMalahmeh Adel J · New Iberia, LAN10961Mcphillips Flying Service Inc · Beaver Island, MIN10965Clampitt Darrell · Gray, GAN1096TEvans Charles B · Benbrook, TXN1096UBraten Randall O · Cody, WYN1097MNunes Lindybergh Jr · Laporte, INN1097THorizon Aviation LLC · Brooks, GAN10987Andreassen Ray E · Delta Junction, AKN10989Rickert Randy M · Lehighton, PAN1098EKruse Robert M · Liberty, MON1098MBingham John R · Leawood, KSN1098UKane Patrick · Chicago, ILN10990Speed And Angels LLC · Dover, DEN109BLGraber Raymond B II · Carson City, NVN109CFMarigi William Kihara · Worcester, MAN109CQWatkins Eric Brian · San Diego, CAN109DMNance David · Cross Roads, TXN109FRWilson Ronald Earl · Sedona, AZN109GPCash Management Consulting LLC · Granite Springs, NYN109HJStk Construction And Development Inc · Temecula, CAN109JLFouts Benjamin Cody · Kailua Kona, HIN109LASullivan Bradley · Tomball, TXN109PSStanley Patrick L · League City, TXN109RDValiair Lc Trustee · Casper, WYN109RVLuck Richard S · Superior, WIN109RWMcpherson Michael A · Stephenville, TXN10ABAm Defense · St Johns, FLN10AVMaak Holdings LLC · Missoula, MTN10BJGrifa Nathaniel A · Waterloo, NYN10BWAce Aircraft Co Inc · Toccoa, GAN10BYKing Air LLC · Navasota, TXN10CGWhitby Christopher W · Prescott, AZN10CKKenny Edward P · Montauk, NYN10CRCarlile Aviation LLC · Peculiar, MON10CXAlameda County Sheriffs Office · Livermore, CAN10DEDragoo Robert E · Raleigh, NCN10DJNovak Todd · Lumberton, NJN10DTBernath Jacob D · Indianapolis, INN10DUOut There Outfitters LLC · Boise, ID
Back to AD 2026-22-13