Registered aircraft · 11,798

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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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.

N58PFVeilleux Jean-Christophe · Escondido, CAS/N TH-888 N58PWPapa Leasing LLC · Helena, MTBuilt 1974 · S/N TH-459 N58QPHk Ventures LLC · Paynesville, MNBuilt 1990 · S/N TH-1612 N58RHHubbard Robert R Dds · Harrison, ARBuilt 1973 · S/N TH-362 N58SGZetroz Systems LLC · Trumbull, CTBuilt 2026 · S/N 525-1403 N58SLHome Air Inc · Gainesville, GABuilt 1980 · S/N TH-1121 N58SSHill Rick A · San Antonio, FLBuilt 1980 · S/N E-1734 N58SZRising Wings Aviation LLC · Walnut Creek, CAS/N TH-2090 N58TPDiamond Aircraft Corporation · Miami, FLBuilt 1977 · S/N TH-843 N58TWHouck Christopher · Cary, NCBuilt 1973 · S/N TH-369 N58UATunica Air Inc · Tunica, MSBuilt 1980 · S/N TH-1194 N58WFHohlrieder Automotive Co · Yorktown, VABuilt 1977 · S/N TH-831 N58WGN58wg LLC · Shreveport, LABuilt 1972 · S/N TH-208 N58ZPCk Investor Inc · Lubbock, TXS/N 421C0705 N590AKt Aviation LLC · Las Cruces, NMBuilt 1989 · S/N 560-0029 N590ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35687 N590FPJk Aircraft Options LLC · Aripeka, FLS/N 5600087 N590SHAlliance Air Parts Acquistions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 1977 · S/N LJ-753 N590TCLear Holding Corp · Wilmington, DEBuilt 1983 · S/N 082 N591AWCsi 135 Division LLC · Albuquerque, NMBuilt 1995 · S/N LJ-1397 N591CFKmw Flight LLC · Wilmington, DEBuilt 1989 · S/N 258175 N591DKIron Ring Aviation LLC · Portland, ORBuilt 2001 · S/N 560-0591 N591FPJk Aircraft Options LLC · Aripeka, FLBuilt 1981 · S/N 551-0304 N591MMFantasy Flight LLC · Atlanta, GABuilt 1999 · S/N 525-0330 N592AEKilo Alpha Group LLC · Fayetteville, ARBuilt 1990 · S/N FL-23 N592ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35190 N592MABg LLC · Bozeman, MTBuilt 1996 · S/N 560-0372 N592SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 208B2066 N592VPKracum Laura T Trustee · Miami, FLS/N 560-0092A N593ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35107 N593EXMarana Tactical Flight LLC · Tucson, AZBuilt 2014 · S/N 208B5093 N593GGCircle S Air LLC · Wilmington, DEBuilt 1980 · S/N BB-593 N593RAMakonnen Iyob · Atlanta, GABuilt 1981 · S/N TH-1307 N593TCGarmin International Inc · Olathe, KSBuilt 2015 · S/N 20800576 N593WTSabin Lake Aviation LLC · Rogers, MNBuilt 2014 · S/N 525-0839 N594ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35191 N594SCMag Ds Corp DBA · Tysons, VABuilt 2008 · S/N FL-594 N595DCChoice Aviation LLC · San Antonio, TXBuilt 1990 · S/N 650-0179 N595KWGeronimo Aviation LLC · Burlison, TNBuilt 2002 · S/N 560-0595 N595PDRegistration Pending · Camden, DERegistration pendingBuilt 2001 · S/N 258526 N595TMRegional Air Group LLC · Windermere, FLBuilt 1990 · S/N LJ-1255 N596ASAlaska Airlines Inc · Seatac, WABuilt 2008 · S/N 35688 N597AFMoondream 5 LLC · Cypress, TXBuilt 1995 · S/N 650-7057 N597ASAlaska Airlines Inc · Seatac, WABuilt 2008 · S/N 35689 N597BAMca-Plane LLC · Grand Blanc, MIBuilt 2004 · S/N BB1851 N597MMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N BB-720 N597PGuardian Flight LLC · Lewisville, TXBuilt 2000 · S/N LJ-1597 N5981BCollins Gordon Lee Jr · Knoxville, TNBuilt 1980 · S/N E-1776 N598ATWohlford Aviation LLC · Ashland, NEBuilt 1997 · S/N LJ-1499 N598KWRegistered aircraftS/N S550-0098

Back to AD 2006-16-18 R1