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.
N103SJBarnick Air Holdings LLC · Santa Barbara, CAN103TXWilliams Bradley H Jr · Charleston, SCN103URankin Kenneth · Pinellas Park, FLN103UC426th Aero Squadron LLC · Cropwell, ALN103VWVan Wagner Aerial Media LLC · Hollywood, FLN1040XRacette Robert J Jr · Vienna, WVN1041HCentury Flight Systems Inc · Mineral Wells, TXN1041QSwaz Aviation LLC · Mesa, AZN1041SN1041s LLC · Key West, FLN1041URegistered aircraftN1042APetrie Michael · Chugiak, AKN1042EPerez Alexander · Palmer, AKN1042SPiper Cameron · Winchester, VAN1043SAmerican Aviator LLC · Newark, DEN1043UClinton Arlys L · Fair Oaks, CAN10446Schell Brothers II LLC · Rehoboth Beach, DEN1044LFitch Mark · Anchorage, AKN1044NMaule Flight Inc · Moultrie, GAN10457Six Ten Ventures LLC · Cedar Hill, TXN1045JFenn Matthew A · Liberal, KSN1045YRovers Bradley S · Chazy, NYN1046XFarnham Aviation Services LLC · Ames, IAN10470Leary Dan P · Girdwood, AKN1047MChristiansen Aviation LLC · Wilmington, DEN1047UStueve'S Certified Organic Dairy · Oakdale, CAN1047VPoulter Thomas R · Chelsea, MIN1047XHuber Frank B · Maple Grove, MNN1047YDonato Deleonardis · Paulden, AZN10480Piper 66 LLC · Kirksville, MON1048AUnderdahl Kirby L · Hamilton, MTN1048CPalmer Gretchen · Knoxville, TNN1048EPaul John R · Boise, IDN1048TTrotter Thomas J · Bremerton, WAN1048XLogan Colton Dean · Pagosa Springs, CON1049PLamal Thomas K · Fairbanks, AKN104ABPeterson Kevin D · Peoria, AZN104ALDinardi Allen J · Jacksonville, ORN104BLSpiva Brett · Knoxville, TNN104BVSea Horse Sportfishing LLC · Clinton, NCN104CPN7293l LLC · Waxahachie, TXN104DMiller Charles H Jr · Cape Carteret, NCFirst renewal noticeN104DMMcalee Dennis E · Defiance, MON104EHaas Bruce F · Lynden, WAN104FFPlane Fun Inc Tr Trustee · Snellville, GAN104FGWilson Conrad · Bowdon Junction, GAN104GKIndigo Bunting Aviation LLC · Morristown, NJN104GPKline Michael S · Gypsum, CON104JDJnk Equipment LLC · Deer Harbor, WAN104LDMasys Daniel R · Lincoln, CAN104LJFeldhousen Larry A · Burlington, CO
Back to AD 2026-22-13