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.

N651SDMontana Jj LLC · Big Sky, MTBuilt 2020 · S/N 20800663 N652SDBakers Bay Caravan LLC · Melbourne, FLBuilt 2021 · S/N 208B5642 N653VTTextron Aviation Inc · Wichita, KSS/N 208B5987 N653WTTextron Aviation Inc · Wichita, KSS/N 208B5991 N661WAKapowsin Air Sports Ltd · Shelton, WABuilt 1998 · S/N 208B0661 N662LMFreedom LLC · Pass Christian, MSBuilt 2002 · S/N 208B0978 N666BZCorrao Ludwig Jerome Trustee · Reno, NVBuilt 2019 · S/N 20800652 N670TCBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 208B2374 N671AZPima County Board Of Supervisors · Tucson, AZBuilt 2021 · S/N 20800671 N671RAReliable Robotics Corp · Mountain View, CABuilt 1996 · S/N 208B0539 N672AZPima County Board Of Supervisors · Tucson, AZBuilt 2021 · S/N 20800673 N6750Z50 Zulu Aviation LLC · Williamston, MIBuilt 2012 · S/N 208B2340 N675JZMercer Fraser Co · Brookings, ORBuilt 2015 · S/N 20800570 N675SMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 20800675 N678GVTextron Aviation Inc · Wichita, KSS/N 208B5975 N679BARowe James D · Nome, AKBuilt 2015 · S/N 208B5251 N682ACDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 2003 · S/N 208B1027 N682BBWright Air Service Inc · Fairbanks, AKBuilt 2015 · S/N 208B-5252 N684SAUnited States Department Of State · Melbourne, FLBuilt 1998 · S/N 208B0684 N688MCFlight Management LLC · Kirkland, WABuilt 2001 · S/N 20800347 N689KAKamaka Air LLC · Honolulu, HIBuilt 2011 · S/N 208B2308 N694DADirect Action Aviation LLC · Reno, NVBuilt 1991 · S/N 208B0266 N699PVHealth Connect Life Sciences LLC · Newark, DEBuilt 2022 · S/N 208B5710 N6CBPk Aviation LLC · Melbourne, FLBuilt 2024 · S/N 20800704 N6RVNrv Aviation LLC · Pleasant Grove, UTBuilt 2026 · S/N 208B5929 N700FXFederal Express Corporation · Memphis, TNBuilt 1994 · S/N 208B0419 N701DLPace J C III · Fort Worth, TXBuilt 2001 · S/N 20800344 N701FXFederal Express Corporation · Memphis, TNBuilt 1994 · S/N 208B0420 N701RPPohlad Robert C · Friday Harbor, WABuilt 2015 · S/N 208B5213 N701SEFlorida Air Cargo Inc · Davie, FLBuilt 1998 · S/N 208B0701 N702FXFederal Express Corporation · Memphis, TNBuilt 1994 · S/N 208B0422 N702PAPriority Air Charter LLC · Kidron, OHBuilt 1998 · S/N 208B0702 N702SEFlorida Air Cargo Inc · Davie, FLBuilt 1993 · S/N 208B0374 N703DCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 20800366 N703FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0423 N704MDNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 2004 · S/N 208B1076 N704RARyan Air Inc · Anchorage, AKBuilt 2024 · S/N 208B5814 N705FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0425 N705JTRegistration Pending · North Salt Lake, UTRegistration pendingBuilt 2025 · S/N 208B5917 N70715State Of Alaska · Anchorage, AKBuilt 1990 · S/N 20800182 N707FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0427 N707HPegasus Adventures LLC · Port Alsworth, AKBuilt 2018 · S/N 208B5447 N707RARyan Air Inc · Anchorage, AKBuilt 2014 · S/N 208B5120 N707WFCannery Leasing Ltd · Friday Harbor, WABuilt 2014 · S/N 20800562 N708RARyan Air Inc · Anchorage, AKBuilt 2020 · S/N 208B5606 N709FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0430 N709RARyan Air Inc · Anchorage, AKBuilt 2018 · S/N 208B5436 N70CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0042 N710FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0431 N711FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0433

Back to AD 2006-01-11 R1