Registered aircraft · 603

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:89-02-10-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-02-10-R1') 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:89-02-10-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-02-10-R1')
  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:89-02-10-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-02-10-R1')
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 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 N105BKJetcom LLC · Lemon Grove, CABuilt 1989 · S/N 070 N1066WAwad Holding Company LLC · Las Vegas, NVBuilt 2004 · S/N 1530 N107GLLeep Enterprises LLC · Mishawaka, INBuilt 2002 · S/N 199 N107TDBopper Airways LLC · Indianapolis, INBuilt 1998 · S/N 1355 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 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 N112EDE D Santos & Associates LLC Trustee · Wilmington, DES/N 258048 N114KSUSA Up Star Air Charters LLC - S Series B · Greenwood, INBuilt 1987 · S/N 1012 N116RWCerovest Capital LLC · Lawrenceville, GABuilt 1988 · S/N 058 N117HHZephyr Air LLC · Houston, TXBuilt 1993 · S/N 258249 N117JTColcot Aviation LLC · New York, NYBuilt 1992 · S/N 258205 N119AFAviation Sales Associates LLC · Costa Mesa, CABuilt 2002 · S/N 1489 N119FMOceanside Aviation LLC · Santa Monica, CABuilt 2001 · S/N 1464 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 N122AVase Corp V · Doral, FLBuilt 1990 · S/N 88 N122LJBas Part Sales LLC · Greeley, COBuilt 1993 · S/N 258239 N123HKTavaero Jet Charter Corp · Houston, TXBuilt 1992 · S/N 258208 N125SBBay Venture Management LLC · Atlanta, GABuilt 1985 · S/N 258046 N129NSHarvey Horses LLC · Wilmington, DEBuilt 1995 · S/N 1281 N12SYMcwalsh LLC · Dover, DEBuilt 1987 · S/N 258103 N130JEReserve Jets Acquisitions LLC · New York, NYBuilt 2000 · S/N 1398 N131JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 1408 N131LGCharter Express Inc · Little Rock, ARBuilt 1988 · S/N 055 N132JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 1403 N137SHDream Global Parts LLC · Lawrence, KSS/N 137 N137WSCf Aviation Trust LLC Trustee · Wilmington, DEBuilt 1997 · S/N 1307 N13SAAvire LLC · Los Angeles, CABuilt 1989 · S/N 1092 N140FJM Investments LLC · San Diego, CABuilt 1995 · S/N 140 N143LPPachy Music Corporation · Bellflower, CABuilt 1988 · S/N 1050 N144ABFly Evolution LLC · La Puente, CABuilt 1988 · S/N 1065 N144PKAvire LLC · West Hollywood, CABuilt 1992 · S/N 1210 N1459AG1459 Leasing LLC · Fort Lauderdale, FLBuilt 2001 · S/N 1459

Back to AD 89-02-10 R1