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.

N444KFSchnell Michael L · Spearman, TXBuilt 1984 · S/N 425-0191 N444LPierwest Aviation LLC · Tulsa, OKBuilt 1980 · S/N LW-344 N444WGSchmucker Real Estate Holdings Lp · Wilmington, DEBuilt 1981 · S/N 31T-8166054 N44508Aeromania LLC · Cheyenne, WYBuilt 2008 · S/N 0101RG N445LLMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2023 · S/N K045 N445MSAas LLC · Ovid, MIBuilt 1994 · S/N 502B-0237 N446QWWkw Operations LLC · Austin, TXBuilt 2020 · S/N 100-0285 N4476FTrans Executive Airlines Of Hawaii Inc · Honolulu, HIBuilt 1987 · S/N SH3731 N447DBGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N LJ-1656 N4488LSouth Texas Aviation Inc · Wilmington, DEBuilt 1995 · S/N LJ-1423 N448CREdwards Mt LLC · Visalia, CABuilt 2013 · S/N LJ-2082 N449CACharlie Alpha LLC · Ketchum, IDBuilt 1999 · S/N 150 N449JSThomas Hanka Aviation LLC · Mission, TXBuilt 1980 · S/N LA100 N44KAHunter Aviation Of Tampa LLC · Saint Petersburg, FLBuilt 2000 · S/N BB-1711 N45019Aerial Solutions Of Tennessee LLC · Milan, TNBuilt 1990 · S/N 502-0090 N450PPJ R S Sky Inc · Pound Ridge, NYBuilt 1975 · S/N 450 N45123Wood Flying Inc · Panhandle, TXS/N 402-0753 N45196Boettcher Aerial Inc · Beloit, KSS/N 402-0755 N4523LWiebe Albert · Seminole, TXS/N 402-0757 N4527XSug-Air LLC · Lubbock, TXS/N 402A-0758 N4528LSkyworks Aviation LLC · Waynesboro, GAS/N 402A-0759 N452GHCrescent Real Estate Investors LLC · Park City, UTBuilt 2005 · S/N 628 N4532FWoodley Aerial Leasing LLC · Walnut, ILBuilt 1990 · S/N 401-0769 N45363South Delta Aviation Inc · West Helena, ARS/N 402-0774 N45368Atlantic Ag Aviation Inc · Felton, DEBuilt 1990 · S/N 401-0775 N4539BWoodley Aerial Leasing LLC · Walnut, ILBuilt 1990 · S/N 401-0763 N4540FWoodley Aerial Leasing LLC · Walnut, ILBuilt 1990 · S/N 402-0784 N4540YTlc Flying Inc · Colfax, WABuilt 1990 · S/N 502-0120 N4541SKankakee Valley Aviation LLC · Wanatah, INS/N 402-0778 N45461Shannon Agricultural Flying Inc · Clarksdale, MSBuilt 1990 · S/N 502-0124 N45469Over & Under Flying Service Inc · Madison, INBuilt 1991 · S/N 402A-0797 N45472Rtc Aviation LLC · Munday, TXBuilt 1991 · S/N 402A-0794 N454CACul8tr LLC · Boynton Beach, FLBuilt 1982 · S/N 31T-8104053 N454LFJamm Aviation Inc · Columbus, OHBuilt 1998 · S/N FL-209 N454SFPa1 208b-0797 LLC · Fort Lauderdale, FLBuilt 1999 · S/N 208B-0797 N45506Mid Continent Aircraft Corp · Hayti, MOBuilt 1991 · S/N 502-0132 N4550NNewberg Sky Spray LLC · Hector, MNBuilt 1991 · S/N 502-0131 N4551MCady Leslie L · Rock Falls, ILBuilt 1991 · S/N 502-0133 N45553Racer Aviation LLC · Moorestown, NJBuilt 1991 · S/N 402-0818 N4555YDevil Dusters Inc · Artesia, NMBuilt 1991 · S/N 402-0812 N4556UAir Care Leasing LLC · Lamar, COBuilt 1991 · S/N 402-0815 N455MMMiklus Enterprises LLC · Middletown, DEBuilt 1980 · S/N 31T-8020087 N455RSTfr Inc · Steamboat Springs, COBuilt 2005 · S/N 4697214 N455SGDdog LLC · San Angelo, TXBuilt 2001 · S/N 4697096 N456LAJaj Flying LLC · Sutton, NEBuilt 2005 · S/N 602-1131 N456SBSurfbird Aviation I LLC · Seattle, WABuilt 2016 · S/N 100-0196 N456SFFejes Samuel T Jr · Anchorage, AKS/N 1683 TB51 N457ATAeronautical Technologies Inc · Clovis, NMBuilt 2005 · S/N 802A-0201 N457VKValkyrie Aero LLC · Mesa, AZBuilt 1995 · S/N 457 N458TPValiair Limited Company Trustee · Casper, WYBuilt 2011 · S/N 100-0050

Back to AD 2002-23-13