Registered aircraft · 11,798

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-16-18-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-16-18-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-16-18-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-16-18-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-16-18-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-16-18-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.

N877JBOg Flights LLC · Dover, DEBuilt 1980 · S/N 421C0877 N877KBBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 650-0024 N877NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31131 N877PAPax Dei LLC · Hot Springs, ARS/N BB-1844 N877RCPlg Aviation LLC · Tucson, AZBuilt 1981 · S/N BB-978 N877TSpecialty Paving Inc · Lincoln, CABuilt 2001 · S/N E-3381 N878BBTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N TH-1710 N878CAKag Aviation LLC · Mc Carley, MSBuilt 1994 · S/N TH-1728 N878CTCarog II LLC · Wilmington, DEBuilt 2013 · S/N FL-858 N878DMFly North 421 LLC · Helena, MTBuilt 1977 · S/N 421C-0413 N878DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31989 N878FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0211 N878JUfly LLC · Wilmington, DEBuilt 2005 · S/N 525-0608 N878KWehco Newspapers Inc · Little Rock, ARBuilt 1998 · S/N LJ-1513 N878MBMb Air LLC · New York, NYBuilt 2002 · S/N 258603 N878NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40768 N878RCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 525-0914 N878STPennsylvania State Police · Hershey, PABuilt 2019 · S/N 208B5526 N878WMortgage And General Investment Corp · Big Bear Lake, CABuilt 2002 · S/N E-3459 N879DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31990 N879FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0213 N879JPRebel Aircraft LLC · Rapid City, SDBuilt 2002 · S/N TH-2030 N879NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31133 N879SADouma LLC · Santa Teresa, NMBuilt 2022 · S/N 525-1129 N879TYKimmel Aviation LLC · Madison, MSBuilt 1978 · S/N BB-498 N87BAUc Aviation Holdings LLC · Union City, TNBuilt 1987 · S/N S550-0131 N87CA200 Knots LLC · Dover, DEBuilt 1983 · S/N TH-1382 N87CFFeltus Aviation LLC · Little Rock, ARBuilt 1983 · S/N BB-1122 N87CHTld LLC · Pasco, WABuilt 1972 · S/N LW-20 N87DATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 208B5745 N87FPMillman Transportation LLC · Saint Louis, MOBuilt 1997 · S/N BB-1565 N87GKAlpha Zulu Aviation LLC · Spring, TXS/N 421C0131 N87HBSierra Alpha Logistics LLC · Fort Lauderdale, FLBuilt 1990 · S/N LJ-1251 N87JFIsr Aviation LLC · Wilmington, DEBuilt 1998 · S/N 208B0657 N87KBKkb Holdings LLC · Wilmington, DEBuilt 2003 · S/N 331 N87MJBerdan Curtis A · Sterling Heights, MIBuilt 1972 · S/N TH-259 N87MVR F Control Inc · New Cumberland, PABuilt 2022 · S/N 208B5677 N87NWAlbatross Air Inc · Beaver, WVBuilt 1978 · S/N BE-42 N87PPAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1976 · S/N 421C0206 N87RBDpm Aviation LLC · Noblesville, INBuilt 1996 · S/N 258299 N87RGCannon William C Jr · Concord, NCBuilt 1998 · S/N TH-1886 N87RMRegistration Pending · Lebanon, MERegistration pendingBuilt 1988 · S/N 208B0114 N87RTPremier Lj40 Inc · Wilmington, DEBuilt 1977 · S/N 106 N87SALiberty Air LLC · Christiansted, VIFirst renewal noticeBuilt 1982 · S/N BB-1089 N87SFSeneca Foods Corp · Penn Yan, NYBuilt 2002 · S/N 560-0616 N87SM10269 Flight LLC · Bainbridge Island, WABuilt 1990 · S/N TH-1587 N87SNB & M Aviation LLC · Theodore, ALBuilt 1998 · S/N 650-7089 N880DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31991 N880DTOklahoma Department Of Transportation · Oklahoma City, OKBuilt 1991 · S/N LJ-1288 N880FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0215

Back to AD 2006-16-18 R1