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.

N369RSEarly Bird Air LLC · Lawrence, MIBuilt 1999 · S/N LJ-1571 N369WTSterling John · Port Lavaca, TXBuilt 1978 · S/N LW291 N36GHMustang High Flight LLC · Boise, IDBuilt 1966 · S/N 1636 N36TGRv Holding LLC · Winchester, MABuilt 1996 · S/N LJ-971 N3700MBoeing Co · Berkeley, MOBuilt 1980 · S/N LW-340 N370UBoard Of Regents Of The University Of Oklahoma · Norman, OKS/N LJ-1428 N373HDHinkle Air Spray Inc · Cavalier, NDBuilt 2001 · S/N 502B-0636 N373KATvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2026 · S/N 100-0373 N375BCYellowstone Leasing LLC · Pray, MTBuilt 1991 · S/N FL-56 N375RDDodson International Parts Inc · Rantoul, KSBuilt 2000 · S/N 4697003 N377LAFickes Aerial & Ag Services LLC · Norfolk, NEBuilt 1996 · S/N 502B-0377 N378AWSkyline Aviation Services LLC · Miramar, FLS/N UE-378 N378HHGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N 378 N379PMSingle Otter Leasing LLC · Ketchikan, AKBuilt 1961 · S/N 379 N37HDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-48 N37TDTwin Disc Inc · Racine, WIBuilt 1990 · S/N FL-25 N381MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3703 N382MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3704 N383ASLee Holdings & Investments LLC · Marks, MSBuilt 1978 · S/N LJ-747 N383JPAtlanta Air Charter Inc · Kennesaw, GABuilt 1980 · S/N BB615 N383RLRescue 383 LLC · Annapolis, MDBuilt 1999 · S/N UE-383 N38537Optimumedicine LLC · Las Vegas, NVBuilt 1985 · S/N UE-158 N385EMEmerald Aviation Inc · Manassas, VABuilt 1980 · S/N LJ923 N385MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3707 N386AFBank Of Utah Trustee · Portsmouth, NHBuilt 2024 · S/N 2386 N386ARRustic Corp · Fort Worth, TXBuilt 1999 · S/N 208B0787 N386GABarnes Inc · Lewiston, IDBuilt 1978 · S/N LJ-775 N387SCHeritage Aviation Management Ltd · Conroe, TXBuilt 1999 · S/N FM-10 N388EERegistered aircraftBuilt 2019 · S/N 100-0276 N388TWTl Lobo Group LLC · Rockwall, TXBuilt 2000 · S/N 4697018 N38HLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N LJ-1914 N38JVKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1992 · S/N BB-1439 N38SPGibson Air LLC · Park Hills, MOBuilt 2014 · S/N EVO-0053 N38TJWright Aaron Y · Carmel, INS/N EVO-0050 N38VDynamic Avlease Inc · Bridgewater, VABuilt 1968 · S/N LM-105 N38VSNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 1988 · S/N BB-1313 N390PSMcm Holdings Inc · Lincoln, NES/N LW-279 N391ACAmerican Champion Aircraft Corp · Rochester, WIBuilt 1979 · S/N 400-98 N391HCFly-Area LLC · Charleston, SCBuilt 1988 · S/N FA165 N394LAAerial Solutions Of Tennessee LLC · Milan, TNBuilt 1994 · S/N 502B-0242 N394SFCity Wings Inc · St Thomas, VIBuilt 2005 · S/N 20800394 N395AAAdvanced Air LLC · Hawthorne, CABuilt 1991 · S/N FL39 N395ABFr Air LLC · Palm Harbor, FLBuilt 1999 · S/N LJ-1575 N395MBAdvanced Air LLC · Hawthorne, CABuilt 2002 · S/N FL-347 N396FSAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2001 · S/N LJ-1648 N396FWRoute 66 Aerostars LLC · Galena, KSBuilt 1980 · S/N 428001021 N396MFRango Aviation LLC · Mesa, AZBuilt 1992 · S/N BB-1421 N397ALVertol Systems Co LLC · Wilmington, DEBuilt 1990 · S/N 36012 N398RKAir Worthy Inc · Lyon, MSBuilt 1998 · S/N 602-0484 N399CZN399cz LLC · Milwaukee, WIBuilt 1969 · S/N U-91

Back to AD 2002-23-13