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

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

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.

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

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.

N425TVPaine Conquest I LLC · Redmond, WAS/N 425-0176 N425TXContinental Forwarding Services Inc · Laredo, TXBuilt 1981 · S/N 4250039 N425W4js LLC · Holland, MIBuilt 1978 · S/N LW268 N425WBBagdasarian Walter DBA · El Cajon, CAS/N 4250184 N425WDRegistered aircraftS/N 425-0130 N425WFRegistered aircraftAssigned, pending cancellationS/N 4250207 N425WLAirmann LLC · Mount Sterling, KYBuilt 1984 · S/N 4250197 N425XPK&M Aviation LLC · Aberdeen, SDBuilt 1981 · S/N 425-0064 N425YAriel Leasing LLC · Aberdeen, SDBuilt 1984 · S/N 425-0209 N426BCP-51 Investment LLC · Salem, ORBuilt 2017 · S/N 100-0214 N426EMBank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N LJ-1352 N426KMKenmore Air Harbor LLC · Kenmore, WABuilt 1999 · S/N 20800306 N427CTuffy LLC · Fremont, NEBuilt 1995 · S/N 102 N427DDYunus Asim · Saginaw, MIBuilt 1978 · S/N 31T-7820029 N427DMSky Charter LLC · Slidell, LABuilt 1979 · S/N LJ804 N427JSLiechty Automotive Management LLC · Gulf Breeze, FLBuilt 1999 · S/N FL-263 N427NSVisser Ag Inc · Rigby, IDBuilt 2003 · S/N 802A-0153 N427TAAircraft Properties LLC · Hampstead, NCBuilt 1977 · S/N 31T-7720027 N428JJKingrey William S · Richmond, TXBuilt 2014 · S/N 402B-1307 N42EAEscott Aerial Spraying LLC · El Reno, OKBuilt 2012 · S/N 402B-1269 N42FCN42fc Leasing LLC · Ponca City, OKBuilt 1996 · S/N BB-1553 N42ZDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1976 · S/N BC28 N430EMEaglemed LLC · Wichita, KSBuilt 2000 · S/N LJ-1616 N431BGBismarck Air Medical LLC · Bismarck, NDBuilt 1980 · S/N LJ-933 N431ZTZimin Transportation LLC · South Naknek, AKBuilt 1976 · S/N BC-18 N432WAWoodley Aerial Leasing LLC · Walnut, ILS/N 400-0435 N434ARTwin Otter Support Services LLC · Las Vegas, NVBuilt 1974 · S/N 432 N434JBInfinite Horizons LLC · Ruth, MIBuilt 2019 · S/N 100-0261 N4350JPhoenix Equipment Lc · Nickerson, KSBuilt 1982 · S/N 400A-0463 N435CEPacific Fbo Properties LLC · Santa Barbara, CABuilt 1981 · S/N 425-0042 N4365UWright Air Service Inc · Fairbanks, AKBuilt 1991 · S/N 208B0253 N436EAN436ea LLC · Sanford, FLBuilt 1997 · S/N BB-1576 N437WFHewitson Enterprises Inc · Avenal, CABuilt 1981 · S/N BB-962 N438CRKilo Alpha 438 LLC · Edgewater, FLBuilt 1978 · S/N BB438 N438DLLocker Don D · Muleshoe, TXBuilt 2019 · S/N #0038 N439PWN439pw LLC · Destin, FLBuilt 2000 · S/N LJ-1589 N43BGRight Brothers LLC · San Clemente, CABuilt 1994 · S/N FL-117 N43CHMatus Richard J · Fort Worth, TXBuilt 1994 · S/N 4622176 N43CW42f LLC · Key West, FLBuilt 1990 · S/N 20800175 N43GNFlt Level LLC · Missoula, MTBuilt 2010 · S/N LJ-1992 N43KEInternational Air Services Inc Trustee · Carson City, NVBuilt 1988 · S/N EA-484 N43VMN43vm LLC · Fremont, CABuilt 2000 · S/N 46-97005 N43WAWhatever Aviation LLC · Olympia, WABuilt 1970 · S/N LJ-501 N43WHLaurel Malibu LLC · Windber, PABuilt 1982 · S/N 31T-8120068 N440CACc Flight Company LLC · Columbia City, INBuilt 1985 · S/N 42-5501027 N4415FB&G Air Inc · Morgan City, LABuilt 2002 · S/N LJ-1675 N442DSSantori Aviation LLC · Helena, MTBuilt 1994 · S/N 96 N444ASAas LLC · Ovid, MIBuilt 1982 · S/N 400-0438 N444CMDl Aviation Solutions LLC · Jacksonville, FLBuilt 1996 · S/N 152 N444HFJohnson Airspray Inc · Argyle, MNBuilt 1992 · S/N T36-191

Back to AD 2002-23-13