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.

N616EAEmpireair LLC · Spokane Valley, WAFirst renewal noticeBuilt 2005 · S/N 616 N616JBAdams Aerial Solutions LLC · Decatur, ILBuilt 1997 · S/N 402A-1033 N6170XWest Hills Aviation Inc · Huron, CABuilt 1996 · S/N 502B-0372 N6174HWoodley Aerial Leasing LLC · Walnut, ILBuilt 1995 · S/N 402B-0994 N6175STri-Rotor Spray And Chemical · Ulysses, KSBuilt 1995 · S/N 402B-0993 N6176LTrinkle Aviation LLC · Kingsburg, CABuilt 1996 · S/N 502A-0352 N6176YRegistered aircraftBuilt 1996 · S/N 802-0036 N6177JMcginty Flying Service LLC · Jones, LABuilt 1995 · S/N 502B-0327 N617MMCal-Ore Life Flight LLC · Brookings, ORBuilt 2000 · S/N LJ-1587 N617STSartec Corp · Pensacola, FLBuilt 2004 · S/N 208B1044 N6180UParrish Aerial Services LLC · Wilmington, DEBuilt 1996 · S/N 502B-0390 N6181QPioneer Agviation 2 LLC · Holdrege, NEBuilt 1996 · S/N 502B-0395 N6182AA&R Air Inc · Hinsdale, ILBuilt 1994 · S/N BB-1484 N618JCMclean Aviation Services Inc · Napa, CABuilt 2005 · S/N 618 N618MAAir Matrix LLC · Lomita, CABuilt 2005 · S/N 4697218 N618SLewis Aeronautical LLC · San Antonio, TXS/N 618 N619BKClipper Group LLC · Newport Beach, CABuilt 2021 · S/N 100-0291 N619PAPafford Air Of Mississippi LLC · Ruston, LABuilt 1993 · S/N BB-1458 N619TKRegistered aircraftBuilt 2006 · S/N 4697243 N61DJBlack Badge Aviation LLC · Carson City, NVBuilt 1991 · S/N 760380 N61DNDn2 Aviation LLC · Fernandina Beach, FLBuilt 1992 · S/N BB-1438 N61GNGuardian Flight LLC · Lewisville, TXS/N LJ-1421 N61KATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1989 · S/N FA-200 N61QDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1968 · S/N LM-92 N620NRak Tbvr LLC · Middletown, DEBuilt 1957 · S/N 1026 N620WALaboratory Corporation Of America Holdings · Burlington, NCBuilt 2005 · S/N 620 N6211JRk Tn Investments LLC · Rushville, INBuilt 2009 · S/N LJ-1931 N62139A-T Rental Properties LLC · Tivoli, TXBuilt 2016 · S/N T34-434DC N621AKPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N 31T1104014 N621GZHfjw Properties Leasing LLC · Santa Rosa Beach, FLBuilt 1998 · S/N FL-197 N621NHorizon Aviation LLC · Kalispell, MTBuilt 2004 · S/N 4697177 N621SSSinghe Kimal · Houston, TXBuilt 2011 · S/N EVO-017 N621TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 100-0061 N622FCRegistered aircraftN-number assigned, not yet registeredS/N 35048 N622JATri-Rotor Spray And Chemical Inc · Ulysses, KSBuilt 2008 · S/N 502B-2622 N622KMK & M Equipment Co LLC · Chatsworth, CABuilt 1981 · S/N BB-491 N623BALmco · Vandenberg Afb, CABuilt 2005 · S/N 623 N623LANeal Aircraft Inc · Slaton, TXBuilt 2000 · S/N 402A-1127 N626FCFlorida Department Of Agriculture And Consumer · Tallahassee, FLBuilt 1995 · S/N 35088 N626LMOne Percent Aviation LLC · Lewes, DES/N 208B-0694 N626MCBilly Bobs Flying Service LLC · Bay, ARBuilt 2025 · S/N 510-134 N626MMFlying Tricycle LLC · Oakland, CABuilt 2016 · S/N 100-0176 N626NDay William B · Conroe, TXBuilt 1980 · S/N P-545 N627EHHound Dog Enterprises LLC · Terre Haute, INBuilt 1991 · S/N T41-158 N627LANew Frontier Aviation LLC · Fort Benton, MTBuilt 2005 · S/N 802A-0213 N627PCAir First LLC · Kalispell, MTBuilt 1984 · S/N 425501010 N628AAEdge Air LLC · Wilmington, DEBuilt 2022 · S/N 4698222 N628CMav Air LLC · Rigby, IDBuilt 1981 · S/N 425-0041 N628MCAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 516 N628TBJmw Kodiak LLC · Anchorage, AKBuilt 2018 · S/N 100-0243

Back to AD 2002-23-13