Registered aircraft · 1,017

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

N248KAKamaka Air LLC · Honolulu, HIBuilt 2012 · S/N 208B2408 N248PAPofolk Aviation Hawaii Inc · Honolulu, HIBuilt 1988 · S/N 208B0134 N249CCCianbro Corp · Pittsfield, MES/N 208B5094 N249TGHoot Aero LLC · Baton Rouge, LABuilt 2015 · S/N 20800579 N253TATalon Air Service Inc · Soldotna, AKBuilt 1992 · S/N 20800222 N256RPAfrica Inland Mission International Inc · Peachtree City, GABuilt 1995 · S/N 208B0463 N25JAPa1 208b-1212 LLC · Fort Lauderdale, FLBuilt 2006 · S/N 208B1212 N261PJFly Pj LLC · New York, NYBuilt 2018 · S/N 208B5426 N263HPCalifornia Highway Patrol · Mcclellan, CABuilt 2025 · S/N 20800719 N264KPKalinin Partners LLC · Juneau, AKBuilt 2004 · S/N 20800383 N264SVBank Of Utah Trustee · Salt Lake City, UTBuilt 1995 · S/N 208B0462 N265KPKalinin Partners LLC · Juneau, AKS/N 20800375 N269TDGrant Aviation Inc · Anchorage, AKBuilt 2008 · S/N 208B2069 N270CLRegistration Pending · Chesterfield, MORegistration pendingBuilt 1990 · S/N 208B0232 N270HSTextron Aviation Inc · Wichita, KSS/N 20800735 N273HPCalifornia Highway Patrol · Sacramento, CABuilt 2025 · S/N 20800721 N274MCLone Eagle Aeronautica LLC · Duncan, OKBuilt 2014 · S/N 208B5104 N274PMPlanemasters Ltd · West Chicago, ILBuilt 1998 · S/N 208B0705 N276MABank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 20800276 N279PMPlanemasters Ltd · West Chicago, ILBuilt 1997 · S/N 208B0623 N27MGAvion Capital Corp · Anchorage, AKBuilt 1997 · S/N 208B0650 N280HPTextron Aviation Inc · Wichita, KSS/N 20800734 N281PMPlanemasters Ltd · West Chicago, ILS/N 208B-0902 N282MWMetropolitan Water District Of Southern California · Los Angeles, CABuilt 2020 · S/N 208B5598 N282PMPlanemasters Ltd · West Chicago, ILBuilt 2002 · S/N 208B0981 N283PMPlanemasters Ltd · West Chicago, ILBuilt 1999 · S/N 208B0774 N284EXCaravan Ex LLC · Kalispell, MTBuilt 2016 · S/N 208B5284 N286ATN286at LLC · California, MDBuilt 2015 · S/N 208B5227 N286PMPlanemasters Ltd · West Chicago, ILBuilt 1997 · S/N 208B0631 N288AMAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2021 · S/N 208B5641 N288PCWright Air Service Inc · Fairbanks, AKBuilt 2007 · S/N 208B1270 N28ANPa1 208b-0751 LLC · Fort Lauderdale, FLBuilt 1999 · S/N 208B0751 N292BWSkyline Aviation Services LLC · Miramar, FLBuilt 2006 · S/N 20800403 N292SSSkydive Guam Inc · Barrigada, GUBuilt 2005 · S/N 208B1142 N294JSJs Jet Three LLC · Kinston, NCBuilt 2021 · S/N 208B5643 N29ANSouth Aero Inc · Albuquerque, NMBuilt 1999 · S/N 208B0753 N29MGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 208B0812 N2AVRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1985 · S/N 20800057 N303GVState Of Alaska · Palmer, AKBuilt 1996 · S/N 208B0581 N305NCNca Aircraft LLC · Opa Locka, FLBuilt 2013 · S/N 208B5052 N307PRDog Is My Copilot Inc · Jackson, WYBuilt 1996 · S/N 208B0541 N308ADC208b0327 Inc Trustee · Wilmington, DEBuilt 1992 · S/N 208B0327 N308PWTexas Parks And Wildlife Department · Austin, TXBuilt 2025 · S/N 208B5856 N310CHWatermakers Air Inc · Fort Lauderdale, FLBuilt 2016 · S/N 208B-5328 N314TBMountain Gateway Order Inc · Dripping Springs, TXBuilt 2019 · S/N 208B5532 N319TATextron Aviation Inc · Wichita, KSS/N 208B5984 N31SASouthern Airways Pacific LLC · Addison, TXBuilt 2006 · S/N 208B1210 N32009Ecliax LLC · Craig, AKBuilt 1987 · S/N 20800022 N321BABering Air Inc · Nome, AKBuilt 2020 · S/N 208B5613 N3252YPa1 208b-1088 LLC · Fort Lauderdale, FLBuilt 2004 · S/N 208B1088

Back to AD 2006-01-11 R1