Registered aircraft · 11,797

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.

N949BGGabriel Kevin E · Galveston, TXBuilt 1979 · S/N E-1494 N949BWBering Air Inc · Nome, AKS/N BB-1763 N949CFTee Pee Wings LLC · San Angelo, TXS/N BB-1828 N949FMackin Aviation LLC · Scottsdale, AZS/N 20800602 N949JABemo23 Assembly LLC · New York, NYBuilt 1998 · S/N 258362 N949JRScaffold Way LLC · Alto, TXBuilt 1994 · S/N FL-121 N949KAGavair LLC · Pagosa Springs, COS/N FL-445 N949MAMajestic Aviation LLC · Billings, MTBuilt 2002 · S/N BB-1795 N949NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 31192 N949REAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1981 · S/N BB-949 N949SAN501wj LLC · Ottawa Lake, MIBuilt 1985 · S/N 650-0074 N94ALBbj Ventures LLC · Goldsboro, NCBuilt 2001 · S/N 525-0432 N94ARTwin Otter International Ltd · Las Vegas, NVBuilt 1973 · S/N 388 N94AWWright Air Service Inc · Fairbanks, AKBuilt 2019 · S/N 208B5529 N94CDSteel Clad Inc · Greenville, SCBuilt 1980 · S/N LJ-939 N94CHInvestjet LLC · Miami, FLBuilt 1998 · S/N 650-7088 N94EA63nl LLC · Willmar, MNBuilt 1985 · S/N 96094 N94EMSkyclub A36 LLC · Alpharetta, GABuilt 1982 · S/N E-2011 N94HBVms Aviation Services LLC · Ardmore, OKBuilt 1980 · S/N LJ-904 N94JKWestwind Aviation Inc · Plantation, FLS/N E-2149 N94JVSlikker Benn W · Marana, AZBuilt 1991 · S/N E-2625 N94KMBurton Aviation LLC · Burlington, NCBuilt 1997 · S/N TH-1816 N94MTWindway Capital Corp · Sheboygan, WIBuilt 1986 · S/N 20800089 N94PGM Wall Inc · Chesapeake, VAFirst renewal noticeBuilt 1983 · S/N LA-205 N94TJHuber Robert T · West Chester, PABuilt 2002 · S/N TH2029 N94WWZephyr Homes LLC · Sebring, FLBuilt 1981 · S/N E-1817 N9500FGomaco Corp · Ida Grove, IABuilt 2016 · S/N FL-1050 N9505BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0085 N950AMUmb Bank Na Owner Trustee · Salt Lake City, UTS/N 35115 N950ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30087 N950FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0056 N950FHTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 208B5950 N950HIsland Aviation Inc · Houston, TXBuilt 2000 · S/N 307 N950MBLos Angeles County Sheriffs Department · Long Beach, CABuilt 1990 · S/N BB-1372 N950MHSpotted Hawk Aviation LLC · Gunnison, COBuilt 2005 · S/N FL-451 N950NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31194 N950PLlbb Air LLC · Amarillo, TXBuilt 1998 · S/N 525-0234 N950PAJa Flight Services LLC · Sugar Grove, ILBuilt 2004 · S/N 208B1063 N950PCGlobal Empire Trust LLC · Fort Lauderdale, FLBuilt 1996 · S/N 258300 N950QHKsnl Aero LLC · Shawnee, OKS/N 5234 N950RFRandigo LLC · Wilmington, DEBuilt 1989 · S/N 20800150 N950SACrop Dusters LLC · Maurice, IABuilt 1981 · S/N 31T-8166028 N950SVCat Cay Partners LLC · Miami, FLBuilt 2020 · S/N 208B5584 N950TTBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 208B0800 N950VWillow Equipment LLC · Sharon Springs, KSBuilt 1975 · S/N E-747 N951AAAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29538 N951DDPerkin Holding Co Inc · Saint Louis, MOS/N E-3491 N951DSDerrick Schmidt Enterprises Inc · Vinita, OKBuilt 1978 · S/N TH-898 N951FHTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 208B5951 N951LHBeech Time LLC · Lawrence, KSBuilt 1986 · S/N E-2300

Back to AD 2006-16-18 R1