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.

N322WWWest Aviation LLC · Palm City, FLBuilt 2020 · S/N 4698133 N3246SInsync Investments LLC · Dover, DEBuilt 1999 · S/N LJ-1576 N3247BSlowflight LLC · Wilmington, DEBuilt 1964 · S/N 1548 N324JPRm Aviation LLC · Davenport, IAFirst renewal noticeBuilt 2008 · S/N LJ-1921 N324WRenshi LLC · Palm City, FLBuilt 2024 · S/N K059 N3250VK & J Air Services Ltd · Midland, TXFirst renewal noticeBuilt 1995 · S/N BB-1523 N325BMFarm Air Service Inc · Tallulah, LABuilt 2003 · S/N 802A-0144 N325PWWatson 321 Air LLC · Flower Mound, TXBuilt 2023 · S/N 4698273 N3262REaglemed LLC · Wichita, KSBuilt 1999 · S/N LJ-1562 N3263CEaglemed LLC · Wichita, KSBuilt 1996 · S/N LJ-1432 N3263NGuardian Flight LLC · Lewisville, TXBuilt 1999 · S/N LJ-1563 N326CAAlpine Aviation Inc · Provo, UTBuilt 1970 · S/N U-135 N326KWBering Air Inc · Nome, AKBuilt 1990 · S/N BB1360 N327BGGrimsley Aviation LLC · Dallas, TXFirst renewal noticeBuilt 2001 · S/N 4697073 N327MJTour Aviation LLC · Naples, FLBuilt 2005 · S/N 1099 N327MZWdl/Oracle LLC · Tucson, AZBuilt 1998 · S/N 4636160 N327RHealth Care Capital Of North Carolina LLC · Atlanta, GABuilt 1999 · S/N FL-259 N327SFState Of Colorado · Lakewood, COBuilt 2003 · S/N 511 N32973Crop Jet Aviation LLC · Gooding, IDBuilt 1995 · S/N T45-009 N3299KJones Aviation Inc · Biggs, CABuilt 1996 · S/N T45-012 N3299PAir Care Leasing LLC · Lamar, COBuilt 1996 · S/N T42-213 N329ATAirtrex Registration Corp Trustee · Wichita, KSS/N FL-329 N329BRHorizon Air LLC · Lumpkin, GABuilt 2008 · S/N 502B-2633 N329GSAugusta Aviation Inc · Hilton Head Island, SCBuilt 1992 · S/N LJ-1320 N329KHDixie Air Applicators LLC · Itta Bena, MSBuilt 2018 · S/N 502B-3132 N329MMRuegg Aircraft Holdings LLC · Wilmington, NCBuilt 2001 · S/N 192 N329RSolace Aerial LLC · Walnut Hill, FLBuilt 2007 · S/N 502B-2614 N32CARegistration Pending · Fairbury, NERegistration pendingBuilt 2005 · S/N 4697216 N32GWGreat Western Aviation LLC · Seattle, WABuilt 1968 · S/N 1689 TB-57 N32PDynamic Avlease Inc · Bridgewater, VABuilt 1966 · S/N LM-31 N32PZRadiopharmacy Regional Air Services LLC · Tempe, AZBuilt 2011 · S/N LJ-2035 N32RHPor Aviation LLC · Huntersville, NCBuilt 1990 · S/N LJ-1268 N330AVUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N U-230 N330DBBlueskyways LLC · Bend, ORBuilt 1999 · S/N LJ-1542 N330PEUnd Aerospace Foundation · Grand Forks, NDBuilt 2008 · S/N LJ-1917 N331JPSfh Inc DBA · Fargo, NDBuilt 2005 · S/N LJ-1756 N331KECrop Air LLC · Eaton, COBuilt 1982 · S/N 400A-0460 N3324TBlue Aircraft LLC · Ketchikan, AKBuilt 1957 · S/N 205 N332ATAg Solutions LLC · Satanta, KSBuilt 1999 · S/N 802A-0087 N332MSLowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1982 · S/N LJ1023 N333KKHocken Brett Trustee · Lake Oswego, ORBuilt 2013 · S/N 100-0084 N333MLSeneca Flight Group LLC · Clearwater, FLBuilt 2023 · S/N K039 N333QTQ Flight LLC · Bernardsville, NJBuilt 2000 · S/N BB-1702 N333TLBrad And Jill Janecke LLC · Pierre, SDBuilt 1982 · S/N LJ-999 N333XPRichard L Richards Pa Trustee · Coral Gables, FLBuilt 2000 · S/N LJ-1609 N333XXArnot Robert · Stowe, VTS/N 31T-7920038 N334LASun Valley Dusting Co · San Benito, TXBuilt 2019 · S/N 502B-3187 N3356YAdvanced Aviation Services LLC · Sheridan, WYBuilt 1992 · S/N FM-4 N336KTBlue Sky Worldwide LLC · Wilmington, DEBuilt 2001 · S/N 4697033 N336RKBridger Aerospace Group Holdings LLC · Belgrade, MTBuilt 1992 · S/N FL-71

Back to AD 2002-23-13