OpenAirDocs.org
AD 2002-23-13

Registered aircraft · 3,462

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
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:2002-23-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:2002-23-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.

N673PCGarden St Aviation LLC · Fort Myers, FLBuilt 2005 · S/N 673N6754HAviation Communication And Surveillance Systems · Phoenix, AZBuilt 1980 · S/N LJ-891N675BABerry Aviation Inc · San Marcos, TXBuilt 1980 · S/N 675N676LASchlater Ag Air LLC · Minter City, MSBuilt 2009 · S/N 502B-2676N676PCWeeks Kermit A Trustee · Polk City, FLBuilt 2005 · S/N 676N676WTHat L Management Inc · Midland, TXBuilt 1981 · S/N BB-872N677LAWesterlin Harrington Flying Service Inc · Holdrege, NEBuilt 2011 · S/N 502B-2738N677PJmc Air LLC · Dillsburg, PABuilt 1992 · S/N 1019N678ABHeart Rhythm Center Of Mississippi LLC · Flowood, MSBuilt 2001 · S/N 4697041N67BAFlorida State Guard · Tallahassee, FLBuilt 1981 · S/N 425-0007N67BWHarvey Robert B Jr · Fort Worth, TXBuilt 2000 · S/N 46-97011N67CQBeech Baron LLC · Wilmington, NCBuilt 2000 · S/N LJ-1619N67DWDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 31T-7620041N67KDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-24N67KHGlobal Transport Eleven LLC · Fort Myers, FLBuilt 2025 · S/N 100-0345N67TMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 100-0275N681CAJet Air Inc · Galesburg, ILBuilt 1995 · S/N LJ-1414N681SDJefferson County Sheriffs Office · Beaumont, TXBuilt 1993 · S/N LJ-1342N682ACDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 2003 · S/N 208B1027N683KRPeterson Tony D · Humboldt, IABuilt 2004 · S/N 602-0683N683MG1976 King LLC · Scottsdale, AZBuilt 1976 · S/N LJ-683N683TAt Home Acquisition And Development Services LLC · Saint Paul, MNBuilt 2017 · S/N 100-0208N684SAUnited States Department Of State · Melbourne, FLBuilt 1998 · S/N 208B0684N685GSGhavi Enterprises Inc · Kenosha, WIS/N LJ-2097N6868BDoyon Air Transport LLC · Ketchikan, AKBuilt 1958 · S/N 274N687MMBuckeye Fluids LLC · Wilmington, DEBuilt 2002 · S/N LJ-1667N688JB4j A/C Leasing LLC · Port Saint Lucie, FLBuilt 2012 · S/N 502B-2871N688MCFlight Management LLC · Kirkland, WABuilt 2001 · S/N 20800347N68ASValiair Lc Trustee · Casper, WYBuilt 2022 · S/N 100-0307N68BJCrownair LLC · Mansfield, PABuilt 1979 · S/N 31T7920029N68NTUnion Air LLC · Searcy, ARBuilt 2013 · S/N LJ-2092N68NXVerdoorn Daniel C · Lone Tree, COBuilt 2016 · S/N EVO-0068N68TFRegistered aircraftS/N 26N69Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-4N690AKKvichak Lodge Aviation LLC · Weatherford, TXBuilt 2020 · S/N 100-0286N690CKlass Investments LLC · Marksville, LABuilt 2002 · S/N 238N690KABank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N LJ1101N690MAAviation Inventory Resources Inc · Alvarado, TXS/N UE-161N690MFDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 1968 · S/N 121N6925YPleasant Aviation LLC · Mount Pleasant, TXBuilt 1978 · S/N GM-94N692ARN692ar LLC · Kalispell, MTBuilt 1980 · S/N 692N692DADirect Action Aviation LLC · Reno, NVBuilt 1968 · S/N 151N692MPWoodley Aerial Leasing LLC · Walnut, ILBuilt 1992 · S/N 502A-0182N692WGuardian Flight LLC · Lewisville, TXBuilt 2003 · S/N LJ-1692N69359Red Leasing LLC · Juneau, AKBuilt 1967 · S/N 1661TB35N694DADirect Action Aviation LLC · Reno, NVBuilt 1991 · S/N 208B0266N694SVTejas Flying Services LLC · Ganado, TXBuilt 2010 · S/N 502B-2694N695LAMurphree Flying Service Inc · Crystal Beach, TXBuilt 2004 · S/N 602-0695N695STKraemericair LLC · Saint Louis, MOBuilt 2021 · S/N 4698195N696EXSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2019 · S/N NFEX001
Back to AD 2002-23-13