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.

N969PLUS Government · Washington, DCBuilt 2005 · S/N 208B1119 N969TCBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 20800532 N970FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0093 N971FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0094 N971NUS Government · Washington, DCS/N 208B1071 N9720FUnited States Of America · Melbourne, FLBuilt 1989 · S/N 20800144 N972FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0096 N9738BSensor Aircraft LLC · Plano, TXBuilt 1988 · S/N 208B0097 N973FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0098 N974QRTj Air Holdings Inc Trustee · Wilmington, DEBuilt 2016 · S/N 208B5308 N9760BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0102 N9761BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0107 N9762BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0109 N9766BRedding Aero Enterprises Inc · Redding, CABuilt 1988 · S/N 208B0112 N976EWright Air Service Inc · Fairbanks, AKBuilt 2002 · S/N 208B0976 N976FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0103 N977FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0104 N97826Atel Leasing Corp Trustee · San Francisco, CABuilt 2006 · S/N 208B1223 N979FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0228 N979SVSkydive Guam Inc · Barrigada, GUBuilt 2002 · S/N 208B-0979 N97HAWright Air Service Inc · Fairbanks, AKBuilt 1997 · S/N 208B0610 N97XXTaylor 483 LLC · Albuquerque, NMBuilt 2020 · S/N 208B5577 N980FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0108 N980FXFederal Express Corp · Memphis, TNBuilt 1995 · S/N 208B0489 N981FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0110 N9820FPa1 208b-0410 LLC · Fort Lauderdale, FLBuilt 1994 · S/N 208B0410 N9829BSkydive Buckeye · Buckeye, AZBuilt 1988 · S/N 208B0116 N982TPYarab Holdings I LLC · Clearwater, FLBuilt 2019 · S/N 20800651 N983FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0113 N984ACSpirit Air Inc · Salmon, IDBuilt 2009 · S/N 208B2081 N984FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0115 N984JDWuca LLC · Minnetrista, MNBuilt 2007 · S/N 20800413 N985FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0117 N985FXFederal Express Corp · Memphis, TNBuilt 2012 · S/N 208B2369 N986FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0194 N986FXFederal Express Corp · Memphis, TNBuilt 2012 · S/N 208B2377 N986WUS Government · Washington, DCS/N 208B1086 N987FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0201 N987FXFederal Express Corp · Memphis, TNBuilt 2012 · S/N 208B2390 N987RAKeith Mutscher · Georgetown, TXBuilt 2000 · S/N 208B0870 N988FXFederal Express Corp · Memphis, TNBuilt 2012 · S/N 208B2400 N989BWRed Dragon Aviation LLC · Melbourne, FLBuilt 2004 · S/N 208B1058 N989FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0124 N989FXFederal Express Corp · Memphis, TNBuilt 2012 · S/N 208B2403 N98RLLevis Air LLC · Slidell, LABuilt 2018 · S/N 208B5469 N98SPSamaritans Purse · Boone, NCBuilt 2017 · S/N 208B5409 N990FXFederal Express Corp · Memphis, TNBuilt 2011 · S/N 208B2276 N991FXFederal Express Corp · Memphis, TNBuilt 2011 · S/N 208B2279 N992FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0128 N992FXFederal Express Corp · Memphis, TNBuilt 2011 · S/N 208B2288

Back to AD 2006-01-11 R1