Registered aircraft · 1,476

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:93-04-02') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:93-04-02') 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:93-04-02')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:93-04-02')
  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:93-04-02')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:93-04-02')
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.

N100AXApplied Underwriters Inc · Omaha, NEBuilt 1995 · S/N 155 N100BZHartwell Holdings LLC · Dover, DEBuilt 1984 · S/N FA-32 N100HMSchultz David J · Neenah, WIBuilt 1978 · S/N 340A-0559 N100MDHoppe Joel A · Mankato, MNBuilt 1978 · S/N 340A0535 N100MTDevo Leasing LLC · Park City, UTBuilt 1979 · S/N 340A0957 N100UPFj100 LLC · Waco, TXBuilt 1988 · S/N 44 N101WFBl Custom Equipment LLC · Cincinnati, OHBuilt 2003 · S/N 197 N102JEClanky Chankys Aviation LLC · Manalapan, NJBuilt 1999 · S/N 1385 N102WCDac 2020 Inc · Skaneateles, NYBuilt 1978 · S/N 340A0443 N103CWFlying Pigs LLC · Kinston, NCBuilt 1985 · S/N FA64 N105BKJetcom LLC · Lemon Grove, CABuilt 1989 · S/N 070 N1066WAwad Holding Company LLC · Las Vegas, NVBuilt 2004 · S/N 1530 N106SASkyline Aviation Services LLC · Miramar, FLBuilt 1990 · S/N FA206 N107FTRoyce Aviation LLC · Greenville, MSS/N 340A0909 N107GLLeep Enterprises LLC · Mishawaka, INBuilt 2002 · S/N 199 N107TDBopper Airways LLC · Indianapolis, INBuilt 1998 · S/N 1355 N108BKKent Aviation LLC · Midland, TXBuilt 2001 · S/N 305 N108DUBd Giv 3 LLC · Longwood, FLS/N 1149 N108EWDepartment Of The Air Force · Hanscom Afb, MABuilt 1994 · S/N 1256 N108FJBuffalo Valley Ventures Of Tn LLC · Cookeville, TNBuilt 1991 · S/N 108 N108JEMlj1 LLC · Farmers Branch, TXBuilt 2001 · S/N 1458 N108PHYoung Family Aviation LLC · Sugar Grove, ILBuilt 1990 · S/N 87 N108RTMassachusetts Institute Technology · Lexington, MABuilt 1999 · S/N 1387 N109BGAviation Leasing Group Inc · Wilmington, DEBuilt 1982 · S/N NA0310 N10TNPacific Rim Management LLC · Downey, CAS/N 257085 N10XBmd Leasing LLC · Portland, ORBuilt 2001 · S/N 190 N10YUNutrawise Corp · San Clemente, CABuilt 1987 · S/N 1030 N110JWAli Air LLC · Missouri City, TXBuilt 1994 · S/N 1245 N110SNAlliance Aviation Group LLC · Wilmington, DEBuilt 1992 · S/N 1208 N111FJJfm Air LLC · Wilton Manors, FLBuilt 1993 · S/N 128 N111PTpr Aviation LLC · Evergreen, COBuilt 1998 · S/N 1334 N111PJG&L Aviation Services LLC · Las Vegas, NVBuilt 1981 · S/N 340A1234 N111RBClear Skies LLC · Allentown, PABuilt 1978 · S/N 340A0545 N111SSFamily Time Machine LLC · Stuart, FLBuilt 1984 · S/N FA-4 N114KSUSA Up Star Air Charters LLC - S Series B · Greenwood, INBuilt 1987 · S/N 1012 N115BHBighorn Airways Inc · Sheridan, WYBuilt 1982 · S/N 340A1531 N115EATso Aviation LLC · Conway, ARBuilt 1978 · S/N 340A0484 N116RWCerovest Capital LLC · Lawrenceville, GABuilt 1988 · S/N 058 N118BHBighorn Airways Inc · Sheridan, WYBuilt 1975 · S/N 340A0003 N118CDFirst Aviation Service Corp · Wilmington, DEBuilt 1977 · S/N NA0212 N119AFAviation Sales Associates LLC · Costa Mesa, CABuilt 2002 · S/N 1489 N119FMOceanside Aviation LLC · Santa Monica, CABuilt 2001 · S/N 1464 N11JARegistration Pending · Denison, TXRegistration pendingBuilt 1977 · S/N 340A0292 N120HAAstley Mark C · Wayne, NJBuilt 1977 · S/N 340A0295 N120JJAviation Sales Associates LLC · Costa Mesa, CABuilt 1995 · S/N 1264 N120SBHrs Aircraft LLC · New York, NYBuilt 2001 · S/N 1462 N120WJFly Vulture Aviation LLC · Southwest Ranches, FLS/N 1004 N1210NTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1991 · S/N 105 N121APCrossland Global Sky LLC · Rogers, ARBuilt 1994 · S/N 1239 N121CBClark Andrew R · Woodside, CABuilt 1976 · S/N 340A0087

Back to AD 93-04-02