Registered aircraft · 3,461

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.

N1130JN1130j LLC · Huntsville, TXBuilt 1997 · S/N LJ-1467 N1132FUS Government · Washington, DCBuilt 1999 · S/N 208B0741 N113SHHill Lawrence E · Marion, MTBuilt 1970 · S/N B-18 N114BAAustin Bill DBA · Sparta, TNS/N 42-8001027 N114HBEaglemed LLC · Wichita, KSBuilt 1996 · S/N BB-1533 N114JPJohnson Airspray Inc · Argyle, MNS/N T34-033 N114WLThompson Flying Service LLC · Charleston, MOBuilt 2014 · S/N 502B-2960 N1154FTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 208B1065 N115CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0011 N115CTChastang Lawrence · Orlando, FLBuilt 1999 · S/N BB-1669 N115LABank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 402B-1152 N115TTNo Delay LLC · Tickfaw, LABuilt 1992 · S/N FL-74 N115WATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1964 · S/N 110451 N115YSTunnell Darrell · Visalia, CABuilt 1974 · S/N LW126 N11638N3701d LLC · Wilmington, NCBuilt 1983 · S/N LJ-1052 N11692Vertical Transit Corp · Luling, TXBuilt 1978 · S/N LJ772 N116KNClear Skies Aviation LLC · Reserve, MTBuilt 2008 · S/N 402B1202 N117BBKustatan Leasing LLC · Nikiski, AKBuilt 1962 · S/N 1511 N117CWestern Enterprise LLC · Pueblo, COBuilt 1996 · S/N LJ-1433 N117EGFcs Aircraft Inc Trustee · Wilmington, DEBuilt 2014 · S/N 100-0117 N117EMAdams Aviation Services Inc Trustee · Wilmington, DES/N UE-114 N117LHEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1997 · S/N LIV-226 N117MLBroceliande LLC · San Francisco, CABuilt 2014 · S/N EVO-0051 N117NURegistered aircraftBuilt 1998 · S/N 4636138 N117PWCommand Air LLC · Arlington, VABuilt 2001 · S/N 4697030 N117TJCoastal Community Real Estate Group LLC · Caswell Beach, NCBuilt 1980 · S/N LA17 N1188G207rs LLC · Santa Feon, NMBuilt 1984 · S/N 425-0202 N118AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1985 · S/N 468508019 N118GTWright Jeffry William Trustee · Milford, DEBuilt 2014 · S/N LJ-2118 N118HBTd Air LLC · Cromwell, CTBuilt 1980 · S/N 31T-8004052 N118KTKranze Technology Solutions Inc · Des Plaines, ILBuilt 2004 · S/N 208B1077 N118MDAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-118 N118SBEaglemed LLC · Wichita, KSBuilt 1996 · S/N BB-1541 N119QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1995 · S/N 119 N119WGHigh Performance Helicopters Corp · Crestline, CABuilt 2005 · S/N 14502 N11DGAir Grace LLC · Blanco, TXBuilt 2024 · S/N K060 N11EBS&J Aviation LLC · Sevierville, TNBuilt 2006 · S/N LJ-1795 N11LWDearing And Jones Pc · Flower Mound, TXBuilt 2016 · S/N EVO-0072 N11TKBelfort Aviation LLC · Park City, UTBuilt 2010 · S/N EVO-006 N11WNRds Aviation LLC · Elkhart, INBuilt 1982 · S/N LA177 N12Federal Aviation Administration · Oklahoma City, OKBuilt 2009 · S/N LJ-1966 N120KQMission Aviation Fellowship · Nampa, IDBuilt 2014 · S/N 100-0120 N120QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1995 · S/N 120 N120RLIsr Platforms LLC · Mclean, VABuilt 1979 · S/N BT-9 N120WWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2001 · S/N 4697047 N1212WTwo Drakes Air LLC · Lizella, GABuilt 1994 · S/N LJ-1381 N1213SWright Caravan LLC · Seattle, WABuilt 1995 · S/N 20800243 N12155International Air Services Inc Trustee · Carson City, NVBuilt 1996 · S/N 208B0562 N121CMSpace Coast Aircraft Co · Merritt Island, FLBuilt 1993 · S/N 208B0336 N121HARedding Aero Enterprises Inc · Redding, CABuilt 1988 · S/N 208B0069

Back to AD 2002-23-13