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.

N650ABBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 650-7074 N650ACTen X Express LLC · Fort Myers, FLBuilt 1996 · S/N 650-7065 N650AHNice Trip LLC · San Juan, PRBuilt 1987 · S/N 650-0139 N650ASSky Bus Inc · North Miami Beach, FLS/N 650-0002 N650ATN650at LLC · Punta Gorda, FLBuilt 1993 · S/N 6507035 N650BCSolid Rock Construction Development Services LLC · Portsmouth, OHBuilt 1981 · S/N 501-0192 N650CBSzucs Attila · Port Orange, FLBuilt 1985 · S/N 650-0084 N650CGC G Bretting Manufacturing Co Inc · Ashland, WIBuilt 1984 · S/N 6500023 N650CJViggiano Aviation LLC · New Haven, INBuilt 1994 · S/N 650-7044 N650CMYc Equipment Co LLC · Orangeburg, SCBuilt 1992 · S/N 560-0177 N650CWTrec Investments LLC · Columbia, MOBuilt 2023 · S/N 525-1153 N650CZTeam Aero LLC · Shawnee, KSBuilt 1995 · S/N 650-7050 N650FCOrion Igv LLC · Opa-Locka, FLBuilt 1987 · S/N 650-0146 N650FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 726 N650GCBank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N 650-0215 N650HGHamlin Aviation LLC · Ormond Beach, FLBuilt 1985 · S/N 6500083 N650JAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1985 · S/N 650-0090 N650JLEncore Jet Management LLC · San Antonio, TXBuilt 1999 · S/N 650-7101 N650KPJt95 Airways LLC · Concord, CABuilt 1985 · S/N 650-0095 N650NVNion LLC · New Century, KSBuilt 1997 · S/N 560-0429 N650PFAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1988 · S/N 650-0154 N650PJSouthwest Aviation Inc · Marshall, MNBuilt 1995 · S/N 650-7059 N650PTBurkim LLC · Hartland, WIBuilt 1989 · S/N 650-0169 N650RARomeo Alpha LLC · Addison, TXBuilt 1995 · S/N 650-7047 N650RCRosado William · Moosic, PABuilt 1993 · S/N 6507029 N650RPRussell Air LLC · Madison, INBuilt 1988 · S/N 650-0157 N650RTGlobal Aero Aviation Inc · Houston, TXBuilt 1985 · S/N 650-0089 N650SFBas Part Sales LLC · Greeley, COBuilt 1984 · S/N 650-0034 N650SGMerlin One Aircraft LLC · San Antonio, TXBuilt 1990 · S/N 6500191 N650TASale Reported · Greeley, COSale reported, pending cancellationBuilt 1985 · S/N 650-0088 N650TWKwafr LLC · Richland Hills, TXBuilt 1997 · S/N 650-7082 N650WMerlin One Aircraft LLC · San Antonio, TXBuilt 1994 · S/N 650-0237 N650WAWings Aloft Incorporated · Portland, ORS/N 650-0047 N650WTRiver Bay Aviation N650wt LLC · Jacksonville, FLBuilt 1998 · S/N 650-7094 N650YRWailea Aircraft LLC · Kamuela, HIBuilt 1981 · S/N E-1932 N6514TTextron Aviation Inc · Wichita, KSS/N 208B5981 N651CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 650-7119 N651CJWpi Equipment LLC · Baker City, ORBuilt 2000 · S/N 525-0365 N651CVAlvista Aviation LLC · Lewes, DES/N 650-0036 N651EJComprehensive Energy Aviation LLC · Longwood, FLBuilt 1995 · S/N 650-0241 N651EMWv Jet Experience LLC · Charleston, WVBuilt 1984 · S/N 650-0030 N651FEFederal Express Corporation · Memphis, TNBuilt 1994 · S/N 728 N651SDMontana Jj LLC · Big Sky, MTFirst renewal noticeBuilt 2020 · S/N 20800663 N651SFN444cw Partners LLC · Spring, TXBuilt 1984 · S/N 650-0063 N651TCItc Equipment LLC · Novi, MIBuilt 2013 · S/N FL-842 N651TM305 Sky LLC · Boca Raton, FLBuilt 1981 · S/N BB-804 N6525Sacramento Computer Power Inc · Sacramento, CABuilt 1977 · S/N E-1173 N65288Tammen Eric W · San Pedro, CABuilt 1983 · S/N E-2062 N652CCSu-N16 LLC · Oak Creek, WIBuilt 1999 · S/N 650-7107 N652EEAerotrust Services Corp Trustee · Wilmington, DEBuilt 1992 · S/N 26526

Back to AD 2006-16-18 R1