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.

N606TWhitney Richard E Jr · Warrenton, VABuilt 1977 · S/N E-1155 N606WJHawker 800xp LLC · Fort Lauderdale, FLBuilt 2002 · S/N 258606 N6073SLocke Mary · Sherman, TXBuilt 1975 · S/N E-776 N6074SWatson Glenn M · Round Rock, TXBuilt 1975 · S/N E-778 N6075SJohnson Jamie D · Leonard, TXBuilt 1975 · S/N E-780 N6077SMcdaniel Leigh W · Orland, CABuilt 1977 · S/N E-962 N6078SWhisero Aero Inc · Tullahoma, TNBuilt 1975 · S/N TH-625 N607ASAlaska Airlines Inc · Seattle, WABuilt 1999 · S/N 29751 N607CFRedstar Air Shows Inc · Discovery Bay, CABuilt 1976 · S/N 306-118 N607DBDeductionpros LLC · Longview, TXBuilt 1998 · S/N 525-0269 N607FJGuardian Flight LLC · Lewisville, TXBuilt 2006 · S/N BB-1963 N607TCState Of Alaska · Anchorage, AKBuilt 2018 · S/N 20800607 N607TNWinging It LLC · Little Rock, ARBuilt 2007 · S/N 525-0662 N6087SVega Peter · Thrall, TXBuilt 1975 · S/N E-784 N608BCSteiner Gp LLC · Weatherford, TXBuilt 1993 · S/N 560-0235 N608BGN A S A Lyndon B Johnson Space Center · Houston, TXS/N 430 N608CEEmb Aviation LLC · Tulsa, OKBuilt 2002 · S/N 560-0608 N608CTHuf Aviation LLC · Waxahachie, TXBuilt 1990 · S/N 560-0065 N608DBDoor 4 LLC · Deadwood, SDBuilt 1997 · S/N 525-0179 N608EBPinnacle Roof Solutions LLC · New Baden, ILBuilt 1979 · S/N E-1512 N608FBVortex Education Management LLC · El Cajon, CABuilt 1979 · S/N LJ-878 N608KGNlh Aviation LLC · College Station, TXBuilt 1997 · S/N 525-0194 N608MMBerry Air LLC · Millwood, GABuilt 1995 · S/N 525-0104 N608PBU.S. Air Force Life Cycle Management Center · Wright Pat Afb, OHBuilt 2020 · S/N 208B5608 N6091SAir Transport Inc · Liberal, KSBuilt 1975 · S/N E-787 N60958Umb Bank Na Trustee · Salt Lake City, UTS/N 60958 N6096SMortensen Daniel R Trustee · Newhall, CABuilt 1975 · S/N TH-699 N6097SDonbee Farms Inc · Brawley, CABuilt 1975 · S/N E-789 N609ASAlaska Airlines Inc · Seattle, WABuilt 1999 · S/N 29752 N609BGKing B100 LLC · Saint Petersburg, FLS/N FL-468 N609MTValiair Lc Trustee · Casper, WYS/N S550-0123 N609RBAviation Group Jmj Inc · Callahan, FLExpired dealer, pending cancellationBuilt 1984 · S/N 258019 N609SMCarlinda Lp · Charles City, IAS/N 5250247 N60BABemidji Aviation Services Inc · Bemidji, MNS/N LW-79 N60BTReklaw Management Co · Houston, TXBuilt 1987 · S/N 432 N60CNMewbourne Oil Company · Tyler, TXBuilt 1996 · S/N FL-139 N60DLAdams Leasing LLC · Gulf Breeze, FLS/N FL-446 N60DRSudeep Singh Flllp · Clovis, CABuilt 1978 · S/N E-1214 N60EDKamal Ronny · Chicago, ILBuilt 1985 · S/N E-2241 N60EWSolomon Mark Trustee · Wilmington, DEBuilt 1999 · S/N 501-0319 N60GCJng Services Inc · Lexington, KYBuilt 2018 · S/N FL-1150 N60GMInternational Air Services Inc Trustee · Carson City, NVS/N 421C-0828 N60LPLowpass Aviation Services LLC · Germantown, TNBuilt 1977 · S/N E-1061 N60MJAlpine Aviation Inc · Provo, UTBuilt 1993 · S/N UE-60 N60NECub Crafters Resale LLC · Yakima, WABuilt 1978 · S/N E-1209 N60SASandbar Air LLC · Rockwood, MEBuilt 2001 · S/N FL-325 N60TJArk Leasing Inc · Newport Beach, CABuilt 1977 · S/N BE-21 N60VPGuardian Flight LLC · Lewisville, TXBuilt 1998 · S/N LJ-1516 N60WATextron Aviation Inc · Wichita, KSS/N 20800729 N6108EMid America Sprayers Inc · Ulysses, KSBuilt 1981 · S/N E-1939

Back to AD 2006-16-18 R1