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.

N7ZGHhwr Whitetail Ranch LLC · Waco, TXBuilt 1984 · S/N 650-0031 N80Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-15 N80000Mccue Mark K · Gualala, CABuilt 1992 · S/N E-2741 N8003RBig Sky Bonanza Inc · Wilmington, DEBuilt 1990 · S/N E-2558 N8008KKraus Lee G Jr · Port Orange, FLBuilt 1990 · S/N E-2559 N800ACTango Gulf LLC · Naples, FLBuilt 1962 · S/N 500A-1193-65 N800AFJec Hawker LLC · Pflugerville, TXS/N 258158 N800BSM&F Western Products Inc · Sulphur Springs, TXBuilt 1998 · S/N BB-1620 N800CFSparky'S Air LLC · Wilmington, DEBuilt 1990 · S/N TH-1599 N800CJCdmr Pj LLC · Jackson, NJS/N 258081 N800CXColeman James M · Aiken, SCBuilt 1979 · S/N E-1435 N800DTN800dt LLC · Wilmington, DEBuilt 1994 · S/N 525-0092 N800EASalt Whistle LLC · Newark, DEBuilt 2002 · S/N 258582 N800EGAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1990 · S/N 258182 N800FJAstra Aircraft Holdings Corp · Wilmington, DES/N NA0428 N800GMCadre Aviation Services LLC · San Antonio, TXBuilt 1985 · S/N 650-0077 N800GNJaunt Jet LLC · Spring, TXBuilt 1998 · S/N 258372 N800JMGreen Chair Productions Inc · Wichita Falls, TXS/N NA0421 N800LQAdc Aviation LLC · Birmingham, ALBuilt 2001 · S/N 258551 N800MAMarco Aviation LLC · Nazareth, PABuilt 1998 · S/N 258369 N800NBN800nb LLC · Minneapolis, MNBuilt 1997 · S/N 525-0212 N800NGClear Horizons LLC · Greenwood Village, COBuilt 2001 · S/N 258549 N800NJGlobal Empire Trust LLC · Fort Lauderdale, FLBuilt 2000 · S/N 258483 N800NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29564 N800PAVance And Priscilla Hinton LLC · New Braunfels, TXS/N NA0438 N800PEFour C Air Inc · Delano, CABuilt 2000 · S/N 258508 N800PGHelio Aircraft Inc · Fort Lauderdale, FLBuilt 1991 · S/N LJ-1286 N800PKFarmers Oil Co Inc · Anthony, KSBuilt 1981 · S/N BB-982 N800PLN800pl LLC · Fort Lauderdale, FLS/N 258696 N800RGRm13 Air LLC · Wellington, FLBuilt 1993 · S/N 258230 N800SEDodson International Parts Inc · Rantoul, KSS/N NA0425 N800SVAircraft Fidelity Corp Trustee · Dover, DES/N NA0470 N800THHoover Aviation LLC · Nashville, TNBuilt 2004 · S/N 258678 N800TLN800tl LLC · Wilmington, DEBuilt 1998 · S/N 258394 N800TSPetrie Motor Company Inc · Lake Worth, TXBuilt 1982 · S/N BB-1032 N800UKJ W Construction Co Inc · Wise, VABuilt 2002 · S/N 258577 N800UWUniform Whiskey Holdings LLC · Opa Locka, FLBuilt 1998 · S/N 258395 N800VRCkv Express LLC · Minneapolis, MNBuilt 1984 · S/N 258016 N800WAKmwflight LLC · Wilmington, DEBuilt 1988 · S/N NA0414 N800WFVarsity Aviation LLC · Martinsburg, PABuilt 2005 · S/N 258728 N800WHGsmh LLC · Daniel Island, SCS/N 258080 N800WWPnw Transport LLC · Tucson, AZBuilt 2004 · S/N 258661 N800XCommander 500a LLC · Scottsdale, AZS/N E-2696 N800XMFlyteme Aviation LLC · Fort Pierce, FLBuilt 1999 · S/N 258414 N800XRSparks Aviation Ownership LLC · Santa Rosa Beach, FLBuilt 1995 · S/N 258283 N801CBBaugh Aviation Services LLC · Orem, UTBuilt 2001 · S/N 560-0584 N801DZDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31912 N801FLDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 2000 · S/N 208B-0809 N801GGLone Star Land & Cattle Co · Houston, TXBuilt 1993 · S/N FL-92 N801JASpokane Turbine Skydiving LLC · Medical Lake, WABuilt 1985 · S/N 20800009

Back to AD 2006-16-18 R1