Registered aircraft · 163

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

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:86-22-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-22-06') ORDER BY n_number

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:86-22-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-22-06')
  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:86-22-06')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-22-06')
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.

N101TNHillsborough County Sheriffs Office · Tampa, FLS/N 20800587 N104WYWyoming Department Of Transportation · Cheyenne, WYBuilt 2004 · S/N 20800377 N105JFIsr Aviation LLC · Wilmington, DEBuilt 1997 · S/N 20800272 N10BBFayard Enterprises LLC · Wake Forest, NCBuilt 1989 · S/N 20800152 N10YPBmf Jax LLC · Jacksonville, FLBuilt 2020 · S/N 20800666 N1213SWright Caravan LLC · Seattle, WABuilt 1995 · S/N 20800243 N1229XTalkeetna Aero Services Inc · Anchorage, AKBuilt 1992 · S/N 20800212 N124RFRandigo LLC · Wilmington, DEBuilt 1988 · S/N 20800018 N12666Wdr Inc · Grand Forks, NDBuilt 1996 · S/N 20800250 N12XVStormhaul Holding LLC · Taylors, SCBuilt 2021 · S/N 20800678 N1323YState Of Alaska · Anchorage, AKBuilt 2001 · S/N 20800352 N141RFRandigo LLC · Wilmington, DEBuilt 1986 · S/N 20800105 N145GPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 20800722 N152TATuck Aerial Surveys Inc · Big Stone Gap, VAS/N 20800664 N157HJaars Inc · Waxhaw, NCBuilt 2020 · S/N 20800668 N168RFRandigo LLC · Wilmington, DEBuilt 1989 · S/N 20800158 N186SGFeet Wet Aviation LLC · Scottsdale, AZBuilt 2008 · S/N 20800504 N18NRWonderful Pistachios & Almonds LLC · Lost Hills, CABuilt 2018 · S/N 20800610 N20059Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2026 · S/N 20800727 N2007UBank Of Utah Trustee · Salt Lake City, UTBuilt 2026 · S/N 20800725 N200LFAeromarine Holdings LLC · Waukesha, WIBuilt 1989 · S/N 20800149 N208Jmp Aircraft Services LLC Trustee · Wasilla, AKBuilt 2002 · S/N 20800363 N208GERedemption Incorporated · Kodiak, AKBuilt 1986 · S/N 20800062 N208HFStart Skydiving LLC · Middletown, OHBuilt 1987 · S/N 20800116 N208JANv5 Geospatial Inc · Sheboygan Falls, WIBuilt 1997 · S/N 20800269 N208JBBimini Air LLC · Scottsdale, AZBuilt 2009 · S/N 20800516 N208JKBaker Aviation Consulting LLC · Summerland Key, FLBuilt 1998 · S/N 20800281 N208JPRad Aviation LLC · Wilmington, DES/N 20800362 N208JWFayard Enteprrises LLC · Wake Forest, NCBuilt 1986 · S/N 20800166 N208KGAir Services International Leasing LLC · Fort Lauderdale, FLBuilt 2000 · S/N 20800323 N208KPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 20800545 N208KREcho Matrix LLC · Bentonville, ARBuilt 1999 · S/N 208-00304 N208LBCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 20800378 N208MWMetropolitan Water District Of Southern California · Los Angeles, CABuilt 2015 · S/N 20800572 N208PMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 20800511 N209JPBeta Fleet LLC · South Burlington, VTBuilt 2007 · S/N 20800409 N215BTScreen Star Inc Trustee · Wilmington, DEBuilt 2009 · S/N 20800517 N215TXTexas Dept Of Public Safety · Austin, TXBuilt 2012 · S/N 20800542 N218PAPreferred Airparts LLC · Kidron, OHS/N 20800384 N227GHCarlen Aviation LLC · Wilmington, DEBuilt 2022 · S/N 20800688 N228NDNorth Dakota Dept Of Transportation · Bismarck, NDBuilt 2010 · S/N 20800520 N239JRBrykin Leasing Corp · Celina, TXBuilt 2003 · S/N 20800368 N247HPCalifornia Highway Patrol · Sacramento, CABuilt 2025 · S/N 20800720 N249TGHoot Aero LLC · Baton Rouge, LABuilt 2015 · S/N 20800579 N253TATalon Air Service Inc · Soldotna, AKBuilt 1992 · S/N 20800222 N263HPCalifornia Highway Patrol · Mcclellan, CABuilt 2025 · S/N 20800719 N264KPKalinin Partners LLC · Juneau, AKBuilt 2004 · S/N 20800383 N265KPKalinin Partners LLC · Juneau, AKS/N 20800375 N270HSTextron Aviation Inc · Wichita, KSS/N 20800735 N273HPCalifornia Highway Patrol · Sacramento, CABuilt 2025 · S/N 20800721

Back to AD 86-22-06