Registered aircraft · 1,827

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:90-06-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-13') 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:90-06-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-13')
  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:90-06-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-13')
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.

N22JAJet Air Inc · Iowa City, IAS/N 550-1129 N22PCFlying Falcons LLC · Wilmington, DEBuilt 1988 · S/N 550-0583 N230JKBcrc Air LLC · Austin, TXBuilt 2003 · S/N 560-0647 N232CEN232ce LLC · Newberry, FLBuilt 1984 · S/N 650-0067 N232TAAviation Trading Partners LLC · Shawnee, KSS/N 650-0128 N233JKLcr Aviation LLC · Richland, WABuilt 2008 · S/N 560-0797 N234AQDavis Lee Enterprises LLC · Guntersville, ALBuilt 1993 · S/N 560-0234 N237VP560 LLC · Kalispell, MTBuilt 1993 · S/N 560-0237 N237WCMiro Aviation Holdings LLC · Coral Gables, FLBuilt 1980 · S/N 550-0129 N238EJFisher Elizabeth J · Odessa, TXBuilt 1997 · S/N 550-0812 N238JPJjk Acquisitions LLC · Kerman, CABuilt 2002 · S/N 550-1024 N23STGreensky Aviation LLC · Mountain Home, ARBuilt 1978 · S/N BB-375 N23YCZip-O Aviation LLC · Eugene, ORBuilt 2000 · S/N 550-0923 N2411APuerto Rico Air Management Services Inc · Coral Gables, FLS/N 650-0103 N241DSNcb Air Ventures LLC · Lighthouse Point, FLS/N S550-0042 N243SFMn Design Inc · Paradise Valley, AZBuilt 2002 · S/N 560-0593 N247AJCarpe Diem 247 LLC · Evansville, INBuilt 2002 · S/N 550-1006 N247DGN247dg LLC · Lawton, OKBuilt 1990 · S/N 560-0082 N247FJConquest II LLC · Kenner, LABuilt 2008 · S/N 560-0782 N247JMAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1980 · S/N 550-0272 N24DPEncore Cb4 LLC · Aventura, FLBuilt 2006 · S/N 560-0703 N24EWarrior Aviation LLC · Brookwood, ALBuilt 1990 · S/N 550-0651 N24GFT & T Aircraft Holdings LLC · North Salt Lake, UTBuilt 2003 · S/N 560-0639 N24KTFalcon Type Air LLC · Nashville, TNBuilt 1995 · S/N 650-7052 N24QATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 560-0762 N250ADWings Air LLC · Jackson, TNBuilt 2002 · S/N 560-0605 N250PKVandelay America LLC · Newport Beach, CABuilt 2001 · S/N 560-0568 N250TMAbd Equipment LLC · Aledo, TXS/N BB822 N254DRDodson International Parts Inc · Rantoul, KSS/N 560-0607 N254PCAtlantic Wings LLC · New Bern, NCBuilt 1988 · S/N FA-160 N255TCLandhawk Aviation LLC · Lewes, DEBuilt 1990 · S/N 550-0638 N256CPSkymax Aero LLC · Chantilly, VAS/N S550-0033 N257BWGb Aviation Leasing LLC · Mooresville, NCBuilt 1981 · S/N 5500283 N257RMRmc Aviation LLC · Klamath Falls, ORBuilt 1998 · S/N 560-0485 N258BVBrasil Vida Air Services LLC · Miami, FLS/N 560-0258 N259GCotton Tail Transportation LLC · Singer Island, FLBuilt 1975 · S/N BB-62 N25EGGarcia Airways LLC · Virginia Beach, VABuilt 1989 · S/N 650-0167 N25FSBbjs Investments LLC · Waukesha, WIBuilt 1997 · S/N 550-0823 N25GZTvpx Aircraft Soultions Trustee · North Salt Lake, UTS/N S550-0011 N261WRW.R. Meadows Inc · Hampshire, ILBuilt 1997 · S/N 560-0447 N262SPAluminum Eagle LLC · South Jordan, UTBuilt 1984 · S/N FA-33 N263WC24-7 Machinery LLC · Ponca City, OKBuilt 2000 · S/N 550-0944 N26496Cypress Aircraft Sales LLC · Clermont, FLS/N 550-0607 N264GVCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 650-0104 N265CMCharlotte-Mecklenburg Hospital Authority · Charlotte, NCBuilt 1999 · S/N 560-0521 N267WGRajen Air LLC · Clovis, NMBuilt 1994 · S/N 560-0267 N269LSSky King LLC · West Fargo, NDBuilt 1981 · S/N BB-799 N269MLAtlantic Wings LLC · New Bern, NCBuilt 1980 · S/N BB-760 N269TAMadison Ql Partners LLC · Dallas, TXBuilt 2000 · S/N 650-7112 N26APMillennium International LLC · Lees Summit, MOBuilt 1997 · S/N 550-0824

Back to AD 90-06-13