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.

N421WSGandy John B · Conroe, TXBuilt 1977 · S/N 421C0433 N421WTWest One Holdings Inc · Cheyenne, WYBuilt 1978 · S/N 421C0620 N421XLLocaero Services Inc Trustee · Wilmington, DEBuilt 1979 · S/N 421C0803 N421XTAdam & Anya Holdings LLC · Wichita, KSBuilt 1978 · S/N 421C0447 N421XXLong William David · San Antonio, TXBuilt 1976 · S/N 421C0238 N421YBBotsis Aircraft Limited Inc · Chesterland, OHS/N 421C1212 N421YWTrl Aviation LLC · Little Rock, ARBuilt 1984 · S/N 421C1402 N421YYVsa Leasing LLC · Linden, MIBuilt 1980 · S/N 421C0872 N421ZM3tr Aviation LLC · Longview, TXBuilt 1981 · S/N 421C1058 N421ZXBurmingham Don Trustee · Duarte, CAS/N 421C0304 N421ZZ421zz LLC · Wilmington, DES/N 421C1220 N4222ATenax Air LLC · Ridgeland, MSBuilt 2001 · S/N UE-422 N422ASAmerican Aviation Inc · Brooksville, FLBuilt 2004 · S/N LJ-1714 N422ATDec Flight Services LLC · Sandy Springs, GABuilt 2000 · S/N E-3333 N422BNAntares Aviation LLC · Boca Raton, FLBuilt 1973 · S/N 20735 N422CMAerostar Aviation LLC · Tucson, AZBuilt 1981 · S/N 421C1046 N422CSBusiness Jet Managers Inc · Canton, MIBuilt 1988 · S/N 258110 N422DBurton Rick · Vancouver, WABuilt 1982 · S/N 421C1202 N422DBHarron Eric J · Austin, TXBuilt 1978 · S/N E-1386 N422GMMidocin LLC · Southfield, MIBuilt 1976 · S/N 421C0055 N422MMBolt Robert S · Tampa, FLBuilt 1998 · S/N E-3217 N422PJCra Aviation LLC · Dickerson, MDBuilt 1981 · S/N 421C-1038 N422PMDale Aviation Inc · Rapid City, SDBuilt 1995 · S/N LJ1412 N423ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 35206 N423BCarlson Herb Trustee · Dana Point, CAS/N D-1430 N423CLTmt Aero Inc · Perrysburg, OHBuilt 1983 · S/N TH1394 N423EMEaglemed LLC · Wichita, KSBuilt 1987 · S/N BB-1269 N423HKGem Air LLC · Bakersfield, CABuilt 1993 · S/N 560-0245 N423JKKraft John · Lake View, IABuilt 1982 · S/N E1951 N423PPrestige Worldwyde! LLC · Concord Township, OHBuilt 2002 · S/N E 3439 N423SGSworks Aviation LLC · Chicago, ILS/N 258472 N423TMJp Aviation Leasing LLC · Salt Lake City, UTBuilt 1976 · S/N 421C-0107 N424AGDancing On A Dream Inc Trustee · Wilmington, DEBuilt 2008 · S/N 208B2013 N424CPDodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N LA-182 N424EMDale Aviation Inc · Rapid City, SDBuilt 1993 · S/N LJ-1351 N424JAJzj Air LLC · Wilmer, ALS/N 421C0885 N424QLj Sutter Aviation LLC · Shavertown, PABuilt 1990 · S/N TH-1582 N424TTTja Aviation LLC · Miami, FLS/N BB-1964 N4257ST&S Proch Investments LLC · Harrisonville, MOBuilt 1976 · S/N E-939 N42592Tpl Flight LLC · Fish Creek, WIBuilt 1996 · S/N 560-0361 N425BJDodson International Parts Inc · Rantoul, KSBuilt 1987 · S/N RJ25 N425BPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N BB-1773 N425PQuimus Aviation LLC · Townsend, WIBuilt 1998 · S/N E-3175 N425W4js LLC · Holland, MIBuilt 1978 · S/N LW268 N425WHTransportation Services LLC · Huntsville, ALBuilt 2004 · S/N 525-0537 N4260SMueller Phillip Robert · Newbury Park, CABuilt 1977 · S/N E-959 N4262SPeck Crosby S · Meredith, NHS/N E-942 N426DDRare Air Aviation Services LLC · Santa Rosa, CABuilt 1970 · S/N TH-93 N426EDWindsock Aviation LLC · Bridgeport, WVBuilt 2001 · S/N 525-0426 N426EMBank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N LJ-1352

Back to AD 2006-16-18 R1