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.

N314TCTop Cat Aviation LLC · Pelham, ALBuilt 1999 · S/N 258400 N314XAEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1991 · S/N 25314 N3150VSanders John B · Knoxville, TNBuilt 1947 · S/N D-580 N31526Trostel Manfred E · Longboat Key, FLBuilt 1989 · S/N E-2487 N3152ERegional Medical Consulting Pllc · Mebane, NCBuilt 1994 · S/N E-2880 N3153PWhiskey Mike Aviation LLC · Merrimac, WIBuilt 1994 · S/N E-2884 N3159GUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 35119 N3159VHoogestraatcarl W · Bangor, PABuilt 1947 · S/N D-589 N315AWUS Government · Washington, DCBuilt 1992 · S/N FL-91 N315CSN Fl Servicing LLC · Santa Rosa Beach, FLBuilt 1996 · S/N 560-0371 N315EXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 315 N315HCHooper Holdings LLC · Madison, WIBuilt 2000 · S/N 525-0373 N315KAGopher Air LLC · New Richmond, WIBuilt 2012 · S/N FL-823 N315PEWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31261 N315RCRocklyn National LLC · Syracuse, NYBuilt 2000 · S/N 258480 N315RPPro Serve Aviation LLC · Englewood, COBuilt 1997 · S/N LJ-1503 N315SCInternational Skychase Corp · Alachua, FLBuilt 1982 · S/N 130 N315SPSegale Properties LLC · Tukwila, WABuilt 2018 · S/N FL-1160 N315WDoores Aviation LLC · Copper Canyon, TXS/N E-3515 N3160GUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 32277 N3160WPalmetto Wings LLC · Longs, SCBuilt 1973 · S/N E-509 N31644Aquarius Aviation Inc · Miami, FLBuilt 1988 · S/N E-2442 N3164VDisdier David C · Vinita, OKBuilt 1947 · S/N D-595 N3168N3168 LLC · San Antonio, TXBuilt 2026 · S/N 525-1405 N3168WBlack Gold Flying Club Inc · Belvidere, NJBuilt 1974 · S/N E-510 N3169WCoelho Enterprises Inc · Dayton, NVBuilt 1974 · S/N E-512 N316CLCalco 316 LLC · Frisco, TXBuilt 1993 · S/N 6507032 N316DFThacker Orbie A · Wellington, ALFirst renewal noticeBuilt 1997 · S/N TH-1817 N316GBWellsprings Aviation LLC · Winston Salem, NCS/N 103 N316GCMarc Aircraft Holding LLC · Soldotna, AKBuilt 1978 · S/N BB-430 N316JGKoch Eric R · Jasper, TXBuilt 1982 · S/N E-2038 N316MDH&D Bluesky LLC · Kalispell, MTBuilt 1985 · S/N LJ-1104 N316MFMf Property Management LLC · Hattiesburg, MSS/N 258314 N316PAkin Products Inc · Monticello, ARBuilt 1999 · S/N E-3237 N316PFAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31262 N316PJWmj Aviation LLC · Wilmington, DEBuilt 2000 · S/N 525-0405 N316RSTriple Rainbow LLC · Princeton, INBuilt 1987 · S/N FA 139 N316TDBas Part Sales LLC · Greeley, COBuilt 1980 · S/N 312 N316WCEagle Aeronautics LLC · Chicago, ILS/N 421C1047 N316WHWhiskey Hotel Aviation Inc · Middletown, DEBuilt 1999 · S/N 560-0516 N3170BSpring Mountain Enterprises Inc · Corvallis, ORS/N 650-0136 N3170FO'Neill Matthew · Indianapolis, INBuilt 1988 · S/N E-2407 N3171VCarpenter Colt A · John Day, ORS/N D-604 N3172DNorth State Aviators LLC · Cary, NCBuilt 1988 · S/N E-2454 N3172KAnderson Stephen · Loveland, COBuilt 1988 · S/N E-2435 N3173VLae Media Group LLC · Gardner, KSBuilt 1947 · S/N D607 N3173WFlying Hammer Aviation LLC · Crosslake, MNBuilt 1974 · S/N E-513 N3174BBrydon Robert J · Lago Vista, TXBuilt 1994 · S/N TH-1724 N3174TChartwell Services Inc · Wilmington, DEBuilt 1998 · S/N TH-1874 N3176WTarvair Eclipse LLC · Burnsville, NCBuilt 1988 · S/N E-2447

Back to AD 2006-16-18 R1