Registered aircraft · 201

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:84-08-02-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:84-08-02-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:84-08-02-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:84-08-02-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:84-08-02-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:84-08-02-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.

N640RBTalfin Leasing II LLC · Heflin, ALBuilt 1998 · S/N 650-7092 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 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 N650CZTeam Aero LLC · Shawnee, KSBuilt 1995 · S/N 650-7050 N650FCOrion Igv LLC · Opa-Locka, FLBuilt 1987 · S/N 650-0146 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 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 N651CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 650-7119 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 N651SFN444cw Partners LLC · Spring, TXBuilt 1984 · S/N 650-0063 N652CCSu-N16 LLC · Oak Creek, WIBuilt 1999 · S/N 650-7107 N653CCRegistered aircraftBuilt 2000 · S/N 650-7116 N657TCrush72 Inc · Wilmington, DEBuilt 1994 · S/N 650-7042 N660PAFriendly Aviation LLC · Dallas, TXBuilt 1993 · S/N 650-0230 N664MMAquarius Aircraft Leasing LLC · Nashville, TNBuilt 1984 · S/N 650-0037 N67FSBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 650-0029 N682RSAircraft Resource Center Inc · Lakeville, MNBuilt 1992 · S/N 650-7001 N689WTotal Prf LLC · Lewes, DEBuilt 1984 · S/N 650-0045 N700LWAircraft Resource Center Inc · Lakeville, MNBuilt 1986 · S/N 650-0125 N700MHMotor City Aeronautics LLC · Okemos, MIBuilt 1986 · S/N 650-0127 N702SMTeam Aero LLC · Olathe, KSS/N 650-0135 N710VPTx N710vp LLC · Austin, TXBuilt 1999 · S/N 650-7100 N711GFIpo II LLC · Wheeling, ILBuilt 1996 · S/N 650-7075 N711LTBlue Skies Aviation Of Daytona Inc · Ormond Beach, FLBuilt 1993 · S/N 6500232 N725RHEstancia Aviation III LLC · Reno, NVBuilt 1986 · S/N 650-0106

Back to AD 84-08-02 R1