Registered aircraft · 1,185

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:82-23-03-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:82-23-03-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:82-23-03-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:82-23-03-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:82-23-03-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:82-23-03-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.

N362TWInjury Care Center LLC · Alpharetta, GABuilt 1983 · S/N 650-0011 N364CLLacy Clay Trustee · Los Angeles, CABuilt 1981 · S/N 383 N365MRDream Aviation LLC · Lawrence, KSBuilt 1985 · S/N 157 N36BLGo Fast Aviation LLC · El Cajon, CABuilt 1994 · S/N 094 N36SPKentucky State Police · Frankfort, KYBuilt 1985 · S/N 577 N370TPPhmi Aviation LLC · Lewes, DEBuilt 1984 · S/N 650-0059 N3712CF900ex LLC · Minneapolis, MNBuilt 1996 · S/N 04 N373DGAttorney Aviation LLC · Dallas, TXBuilt 2001 · S/N 159 N373RRM10 LLC · Rolling Meadows, ILBuilt 1997 · S/N 259 N375DSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1986 · S/N 650-0119 N375RC2022 Olivia Av LLC · Austin, TXBuilt 2001 · S/N 258565 N376BLSkyview LLC · Wilmington, DEBuilt 1978 · S/N 376 N376DBae Systems Tss Inc · Mojave, CABuilt 1981 · S/N 465-76 N377CHHalcon Equipment Leasing LLC · Midlothian, TXBuilt 1991 · S/N 220 N378MGDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N 428 N37BMLas Express Aviation LLC · Las Vegas, NVBuilt 1994 · S/N 096 N37KJBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 1987 · S/N 173 N381CWN650rj LLC · Marshall, MNBuilt 1986 · S/N 650-0111 N383MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 322 N383MVSouthern Cross Aircraft LLC · Fort Lauderdale, FLBuilt 1999 · S/N 258403 N383TKThk Holdings LLC · Cincinnati, OHBuilt 2004 · S/N 258700 N384PBOvation Jet Parts LLC · Smyrna, DEBuilt 1980 · S/N 384 N385RCTms Global Investments Inc · Naples, FLBuilt 1984 · S/N 117 N386TLTlo Aviation LLC · Ormond Beach, FLBuilt 1990 · S/N 209 N387TSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 018 N388WA2029 Aircraft Trust 2 LLC Trustee · Davie, FLS/N 27 N389AWAir Gato Enterprises Inc · Clearwater, FLBuilt 1977 · S/N 157 N38MGBay Venture Management LLC · Atlanta, GABuilt 1989 · S/N 009 N38PSAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 206 N391BVcs Encore LLC · Austin, TXBuilt 1996 · S/N 258321 N393SCN169px LLC · Delaware, OHBuilt 1989 · S/N 650 N395HEBillron LLC · Houston, TXBuilt 1992 · S/N 228 N395WBCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1998 · S/N 009 N39FNGh Equipment LLC · Dover, DEBuilt 1974 · S/N 006 N39GXPitch N Power Aviation Inc · Jupiter, FLBuilt 1982 · S/N 232205 N400CZDodson International Parts Inc · Rantoul, KSS/N 547 N400GPIcmc Idaho LLC · Salinas, CAS/N 423 N400GSGreen Savoree Transportation LLC · Carmel, INBuilt 2001 · S/N 134 N401JWWatts John I · Murchison, TXBuilt 1975 · S/N 46 N404BYMalagamar LLC · Fort Myers, FLBuilt 1988 · S/N 650-0152 N404DHDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 366 N404FZBogey Bird II Inc · Jeffersonville, INBuilt 1985 · S/N 473 N406CUSs Leasing II LLC · Eau Claire, WIBuilt 1992 · S/N 650-7010 N406TMAlcyone Trust Corp Trustee · Wichita, KSBuilt 2002 · S/N 258578 N40BGAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 2005 · S/N 2041 N40GPBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 45-2061 N411SCRegistered aircraftBuilt 2004 · S/N 258653 N412DAVida Trade And Management Group LLC · Charlotte, NCS/N 258061 N412SWThunderforce Investments LLC · Washington, DCBuilt 2002 · S/N 238 N413HSAerotrust Services Corp Trustee · Wilmington, DES/N NA0413

Back to AD 82-23-03 R1