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.

N914NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 31161 N914SHSanford Medical Center · Sioux Falls, SDBuilt 1999 · S/N BB-1688 N915ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29516 N915APAir Services Corp · Wilmington, DEBuilt 2002 · S/N 258574 N915CDN915cd LLC · Woodland, CABuilt 1977 · S/N LJ748 N915DHDsw Development Co · Cape Girardeau, MOBuilt 2015 · S/N 525-0881 N915DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 62783 N915JFFox James R · St Paul, MNBuilt 1991 · S/N 20800209 N915MRGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N LJ-1637 N915NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33227 N915SFLock Haven Aircraft Sales · Lewes, DEBuilt 1999 · S/N 525-0301 N9169QMedic Choppers LLC · Springdale, ARBuilt 1970 · S/N E-253 N916ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29517 N916BCN916bc LLC · Woodward, OKBuilt 1988 · S/N E-2448 N916DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 64884 N916FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0016 N916KPKp Aviation Management LLC · Mather, CABuilt 2000 · S/N 301 N916NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31163 N916RTAasjng LLC · Holdrege, NEBuilt 1981 · S/N 31T-8166041 N9177QPapst Bonanza LLC · Parker, AZBuilt 1970 · S/N E-257 N9179XJohnson Randolph B · Wichita Falls, TXBuilt 1992 · S/N E2759 N917ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29518 N917APDynamic Chemical Solutions Inc · Frisco, TXBuilt 2016 · S/N 525-0917 N917DCRegistered aircraftFirst renewal noticeBuilt 1981 · S/N E-1884 N917DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 63530 N917GPEpas LLC · Wilmington, DEBuilt 1985 · S/N S5500067 N917GWJoe Morten & Son Inc · South Sioux City, NEBuilt 2023 · S/N 525-1143 N917JKJen-Kel Aviation LLC · Sarasota, FLBuilt 1975 · S/N E-652 N917KWAlta Airlines Holdings LLC · Salt Lake City, UTS/N 46917 N917MPPool Shark Equipment LLC · Memphis, TNBuilt 1981 · S/N TH-1243 N917NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 29572 N917TLCook Childrens Health Enterprises · Fort Worth, TXBuilt 2010 · S/N 560-0812 N917TRTry Trying Management And Promotions LLC · Indianapolis, INS/N TH-133 N917WAN917wa Corp Trustee · Wilmington, DEBuilt 1985 · S/N FA-77 N9183BSteller Aviation LLC · Middletown, DEBuilt 1991 · S/N E-2631 N9187Catalina Air Transport LLC · Long Beach, CABuilt 2002 · S/N 208B0948 N918AJMaciley Av Mgmt LLC · Wilmington, DEBuilt 1998 · S/N 560-0450 N918AMAmdel Holding LLC · Houston, TXBuilt 2003 · S/N 525-0508 N918ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29519 N918BBAlco Aviation Services Consulting LLC · Taft, TNBuilt 1980 · S/N LA113 N918BKSw El LLC · Palestine, TXBuilt 2001 · S/N 525-0419 N918BVDietz John W Jr · Westfield, INBuilt 1982 · S/N 421C1247 N918CACalifornia Highway Patrol · Sacramento, CABuilt 1978 · S/N BC-57 N918DDDiamond D Aviation LLC · Sulphur, LABuilt 1999 · S/N BB-1677 N918DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 64885 N918FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0018 N918LPNew Chat Air LLC · Chattanooga, TNBuilt 2020 · S/N 525-1058 N918MMVegetable Flight Resources LLC · Portland, ORBuilt 1980 · S/N LA-52 N918MTIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 1983 · S/N LA-211 N918NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33228

Back to AD 2006-16-18 R1