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.

N333AHAerotrust Services Corp Trustee · Wilmington, DEBuilt 1993 · S/N 650-0222 N353HAMpr Aviation LLC · Wilmington, DEBuilt 1986 · S/N 650-0109 N362TWInjury Care Center LLC · Alpharetta, GABuilt 1983 · S/N 650-0011 N370TPPhmi Aviation LLC · Lewes, DEBuilt 1984 · S/N 650-0059 N375DSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1986 · S/N 650-0119 N381CWN650rj LLC · Marshall, MNBuilt 1986 · S/N 650-0111 N384EMIsi Aviation Support Services LLC · Broken Arrow, OKBuilt 1987 · S/N 650-0144 N393JCFlycarolina Jet Partners LLC · Charlotte, NCS/N 650-0113 N404BYMalagamar LLC · Fort Myers, FLBuilt 1988 · S/N 650-0152 N406CUSs Leasing II LLC · Eau Claire, WIBuilt 1992 · S/N 650-7010 N413MHFastair Inc · Columbia Station, OHBuilt 1987 · S/N 650-0148 N413RCGreen Steam Aviation LLC · Springfield, ILBuilt 1992 · S/N 650-7017 N427RRTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1990 · S/N 6500178 N430SALks Aviation LLC · Birmingham, MIBuilt 1994 · S/N 650-7041 N43DSDs Air LLC · Carrollton, VABuilt 1992 · S/N 650-7016 N444CWTexas Aero Jet Sales 1 LLC · Wilmington, DEBuilt 1984 · S/N 650-0064 N44MQAircraft Holdings Solutions LLC Trustee · Newark, DEBuilt 1994 · S/N 6507043 N44RFKtpt Capital Holdings LLC · Hilton Head Island, SCBuilt 1985 · S/N 650-0072 N458RMPjs Holdings LLC · Prior Lake, MNBuilt 1995 · S/N 650-7049 N468ESAir Roc Group LLC · Canandaigua, NYBuilt 1990 · S/N 650-0185 N478PAMerlin One Aircraft LLC · San Antonio, TXBuilt 1996 · S/N 6507069 N47ANLagoinha Orlando Church Inc · Orlando, FLBuilt 1984 · S/N 650-0054 N498CSMmu-Cit-Aviation LLC · West Orange, NJS/N 650-0180 N4QNLabutte LLC · Dearborn, MIBuilt 1993 · S/N 650-7031 N500FRInterstellar Air LLC · Gainesville, FLBuilt 1992 · S/N 650-0208 N504TAviationiq LLC · Helena, MTBuilt 1994 · S/N 650-7040 N508RZGeaux Flight LLC · Baton Rouge, LABuilt 1988 · S/N 650-0164 N50TW17 Aviation LLC · Oklahoma City, OKBuilt 1999 · S/N 650-7097 N510SDChg Jets LLC · Orange, CABuilt 1988 · S/N 650-0161 N513TSGully Air LLC · College Station, TXBuilt 1999 · S/N 650-7096 N51JVSky Global LLC · San Juan, PRBuilt 1984 · S/N 650-0050 N534HHec Aviation LLC · Shelbyville, TNBuilt 1991 · S/N 650-0196 N53HAInky Aviation LLC · Sellersburg, INBuilt 1997 · S/N 650-7076 N541SRider Terry · Corinth, MSBuilt 1986 · S/N 6500115 N55BHTop Flight LLC · Gilbert, WVBuilt 1984 · S/N 650-0041 N565KTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 650-0131 N575HARiver City Aircraft LLC · Sellersburg, INS/N 650-7009 N575KTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1988 · S/N 650-0158 N57FSFobl Inc · Juana Diaz, PRBuilt 1991 · S/N 6500204 N583SDMiller Waste Mills Inc · Winona, MNBuilt 1993 · S/N 650-7034 N595DCChoice Aviation LLC · San Antonio, TXBuilt 1990 · S/N 650-0179 N597AFMoondream 5 LLC · Cypress, TXBuilt 1995 · S/N 650-7057 N59FTSt Andrews Aircraft LLC · West Palm Beach, FLBuilt 1986 · S/N 650-0123 N6110Solidwood Aviation Express LLC · Waller, TXBuilt 1993 · S/N 650-7023 N611ATN611at LLC · Punta Gorda, FLBuilt 1987 · S/N 650-0143 N618JGChris Jenschke LLC · Poteet, TXBuilt 1995 · S/N 650-7055 N622PMChoice Aviation LLC · San Antonio, TXBuilt 1993 · S/N 650-7027 N623PMLal Holdings LLC · Gallatin, TNBuilt 1992 · S/N 650-7018 N629MDAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1985 · S/N 650-0096 N63FXTrn Aviation LLC · Lewes, DEBuilt 1994 · S/N 6500234

Back to AD 84-08-02 R1