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.

N64FFSanford Health · Sioux Falls, SDBuilt 2000 · S/N FL-308 N650BGP & M Aero LLC · Belle Chasse, LABuilt 2005 · S/N 654 N650DMMaroon Creek LLC · Aspen, COBuilt 1993 · S/N 85 N650MCN650mc LLC · Bountiful, UTBuilt 2005 · S/N 650 N651PBJm Aviation LLC · Ocala, FLBuilt 2005 · S/N 651 N652JWWalters Aviation LLC · Hilliard, OHBuilt 2021 · S/N 4698188 N653DPBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N FA-193 N654AFTexas A&M Concrete LLC · Houston, TXBuilt 2008 · S/N LJ-1905 N654FMN654fm LLC · Kalispell, MTBuilt 1980 · S/N BB-654 N655MWMarvin Lumber And Cedar Company · Warroad, MNBuilt 1999 · S/N UE-377 N655SCStandridge Color Corp · Social Circle, GABuilt 1999 · S/N FL-239 N655TATommys Flying Service Inc · Sherrill, ARBuilt 2008 · S/N T34-285DC N658LAPontiac Flying LLC · Pontiac, ILBuilt 2003 · S/N 502B-0658 N658PCAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 658 N65AFAngel Fire Express II LLC · Southlake, TXBuilt 2004 · S/N 565 N65BATts Leasing Inc · Kansas City, KSBuilt 1980 · S/N 31T-8020071 N65HALouisiana Dept Of Wildlife & Fisheries · Baton Rouge, LABuilt 2012 · S/N 100-0065 N65MGRegistered aircraftN-number assigned (import), not yet registeredS/N LA-79 N65MTM&M Transit LLC · Winter Park, FLS/N LA-38 N65MVAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N LJ-1870 N65TADodson International Parts Inc · Rantoul, KSBuilt 1971 · S/N LJ-538 N65UDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-87 N65VDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1968 · S/N LM-113 N660KPWorsham Farms Flying Service Inc · Camilla, GAS/N T660-122DC N660MCMcguires Flying Service LLC · Obion, TNBuilt 2024 · S/N T660-185DC N660TRTri-Rotor Spray & Chemical · Ulysses, KSBuilt 2000 · S/N T660-106 N661EKGi Aviation LLC · Denver, COS/N 61 N661MAAramco Capital Company LLC · DhahranBuilt 1998 · S/N 802A-0057 N661SAPrometheus Air LLC · Middletown, DEBuilt 2005 · S/N 660 N661WAKapowsin Air Sports Ltd · Shelton, WABuilt 1998 · S/N 208B0661 N662AVBerry Aviation Inc · San Marcos, TXBuilt 1980 · S/N 662 N662JKFairmont Aerial Ag Inc · Frost, MNBuilt 2009 · S/N 502B-2662 N662LMFreedom LLC · Pass Christian, MSBuilt 2002 · S/N 208B0978 N662MAAramco Capital Company LLC · DhahranBuilt 1996 · S/N 802-0037 N663LAAurora Cooperative Elevator Co · Aurora, NEBuilt 2003 · S/N 502B-0663 N665JKSprinklermatic Florida LLC · Davie, FLBuilt 1975 · S/N LJ665 N665LAJensen Aviation LLC · Pingree, IDBuilt 2003 · S/N 602-0666 N665MCGrindstaff Aviation Company LLC · Crossville, TNBuilt 2005 · S/N 665 N666JMBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2025 · S/N 2468 N667CBDevil Dusters Inc · Artesia, NMBuilt 2003 · S/N 502B-0667 N669BABlue Air Training Corp · Las Vegas, NVBuilt 1988 · S/N 507 N669JWKapowsin Air Sports Ltd · Shelton, WABuilt 1968 · S/N 088 N669LGFcs Aircraft Inc Trustee · Wilmington, DEBuilt 2010 · S/N 100-0037 N66TGAeroconnection King Air LLC · Miami, FLBuilt 1988 · S/N FA-155 N66WDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-68 N670WHHelimax Aviation LLC · Howell, MIBuilt 2005 · S/N 670 N671BLAtlas Casters LLC · Ashland, ORBuilt 2017 · S/N EVO-0071 N671PCAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 671 N672PBJohnson River LLC · Durant, OKBuilt 2005 · S/N 672 N672SDSweet Darling Sales Inc · Aptos, CABuilt 2005 · S/N 666

Back to AD 2002-23-13