Skip to content

AD 2006-01-11 R1

Registered aircraft · 1,016

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.

N747LALewis Aeronautical LLC · San Antonio, TXBuilt 2017 · S/N 208B5406 N748FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0241 N748FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0503 N749FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0242 N750FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0511 N750KPAircraft Structures International Corp · Enid, OKBuilt 1997 · S/N 208B0628 N750RVWright Air Service Inc · Fairbanks, AKBuilt 2015 · S/N 208B5194 N750ZSouthern Airways Pacific LLC · Addison, TXBuilt 2004 · S/N 208B1054 N751FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0245 N751FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0514 N752FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0247 N752FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0517 N753BABering Air Inc · Nome, AKBuilt 2024 · S/N 208B5798 N753FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0520 N753KPKalinin Partners LLC · Juneau, AKBuilt 2007 · S/N 208B1275 N754FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0526 N754KPKalinin Partners LLC · Juneau, AKBuilt 2007 · S/N 208B1264 N755FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0529 N755KPKalinin Partners LLC · Juneau, AKBuilt 1999 · S/N 208B0759 N755RVWright Air Service Inc · Fairbanks, AKBuilt 2016 · S/N 208B5299 N756FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0532 N7580BMec International Trading LLC · Daytona Beach, FLBuilt 1987 · S/N 208B0051 N7581FDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 1994 · S/N 208B0389 N759BABering Air Inc · Nome, AKBuilt 2021 · S/N 208B5630 N759MRMabarey LLC · Guaynabl, PRBuilt 2023 · S/N 208B5759 N75GMMandes George J · Homer, AKBuilt 2010 · S/N 20800518 N761FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0254 N761RVWright Air Service Inc · Fairbanks, AKBuilt 2016 · S/N 208B5334 N762FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0255 N762RVWright Air Service Inc · Fairbanks, AKBuilt 2016 · S/N 208B5340 N763FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0256 N765FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0259 N767FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0262 N768FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0263 N76AZHubbard Broadcasting · Saint Paul, MNBuilt 1988 · S/N 20800139 N770FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0265 N771FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0267 N772BABering Air Inc · Nome, AKBuilt 2017 · S/N 208B5416 N772FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0268 N773FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0269 N774ATN774at LLC · Leesburg, VABuilt 2008 · S/N 208B2012 N774DLSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1992 · S/N 208B0324 N774FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0271 N774SPSamaritans Purse · Boone, NCBuilt 2013 · S/N 208B5030 N775FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0272 N775KH75 Express Inc · Mooresville, NCBuilt 2020 · S/N 208B5593 N776TFStanking Holdings LLC · Wayzata, MNBuilt 2008 · S/N 20800500 N778DMTextron Aviation Inc · Wichita, KSS/N 208B5985 N778FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0275 N779FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0276

Back to AD 2006-01-11 R1