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.

N31HKN31hk Inc · Miami, FLBuilt 1975 · S/N 016 N31MMPence Air LLC · Edinburg, VAS/N 421C0819 N31SASouthern Airways Pacific LLC · Addison, TXBuilt 2006 · S/N 208B1210 N31SPBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2015 · S/N 525-0874 N31WCPro Serve Aviation LLC · Englewood, COBuilt 1979 · S/N BB-465 N31WEWorldwide Equipment Of Tn Inc · Knoxville, TNBuilt 2000 · S/N 5250362 N31WPSale Reported · Gaylord, MISale reported, pending cancellationBuilt 1974 · S/N LW-99 N31XXTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1990 · S/N FL-31 N31ZZE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1989 · S/N NA0437 N32009Ecliax LLC · Craig, AKBuilt 1987 · S/N 20800022 N3200NLazy Bones LLC · Mitchell, SDBuilt 1998 · S/N E-3200 N3203VGumar Sherko · Scottsdale, AZS/N D-640 N3205VGonzalez Efrain · Manhattan Beach, CABuilt 1994 · S/N E-2899 N3206YN3206y Aviation LLC · Bloomfield Hills, MIBuilt 1994 · S/N E-2903 N3207LRdl Construction Inc · Hollister, CABuilt 1976 · S/N E-935 N3208VIrby Darrell L · Keller, TXS/N D-646 N3209DCirrus 1jr LLC · Webster, NYBuilt 1994 · S/N TH-1735 N3209JDennis John W · Mooresville, NCBuilt 2000 · S/N E-3299 N320CBHoneymoon Properties IV LLC · Winfield, ALBuilt 1993 · S/N 560-0207 N320EJAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258523 N320GWSky Wheeels LLC · Prince Frederick, MDBuilt 1981 · S/N 180 N320MDIsland Jet Aviation Inc · Lewes, DENon-citizen corporation, flight hours not reportedBuilt 1981 · S/N 366 N320MKAdaka-Sb LLC · Orlando, FLBuilt 1982 · S/N 370 N320WDAt Liberty LLC · Apple Valley, MNBuilt 1974 · S/N TH-426 N3211UHc LLC · Troy, ALS/N TH-1911 N3212VIvy James III · Seligman, AZBuilt 1947 · S/N D-650 N3213DMountaingales LLC · Phoenix, AZBuilt 1998 · S/N E3213 N3214ZYounger Aviation LLC · Poteau, OKBuilt 1994 · S/N E-2911 N3215DSchlund James F · Chico, CABuilt 1994 · S/N E-2912 N3215UAileron T LLC · Orlando, FLBuilt 1994 · S/N E-2915 N3216AEvan Charles · Newton, MAS/N E-2900 N3216D747 Aviation LLC · Collierville, TNS/N E2916 N3216KSouth River Services LLC · Myrtle Beach, SCS/N LJ-1392 N3216ZMy Fly LLC · Wilmington, DES/N E-2922 N3217EDavis Darren · Flint, TXBuilt 1995 · S/N E-2926 N3217MN3217m LLC · Polson, MTBuilt 2000 · S/N E-3317 N3218XMjm Flying LLC · Traverse City, MIBuilt 2000 · S/N E-3358 N321BABering Air Inc · Nome, AKBuilt 2020 · S/N 208B5613 N321CEMaroon Sky LLC · Navasota, TXBuilt 1981 · S/N 421C1225 N321CYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1968 · S/N 211 N321DVBonanza Horizon Inc Trustee · Wilmington, DES/N E-2581 N321EMRiomar Sky LLC · Warrington, PABuilt 2023 · S/N 525-1152 N321FDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1979 · S/N BC-70 N321FUTms Turboprop 2xl LLC · Wilmington, DES/N 31T-8166063 N321LBSpeer Transport LLC · El Cajon, CABuilt 1981 · S/N 31T-8166012 N321MSTaughannock Aviation Corp · Ithaca, NYBuilt 2001 · S/N 258515 N321RRambarran Brian D · Clarence Center, NYBuilt 1994 · S/N 525-0049 N321TBMob Aviation USA LLC · Auburndale, FLBuilt 1982 · S/N E-1998 N321TRVertivue LLC · Allentown, PAS/N LA-48 N321VAValiair Limited Co Trustee · Casper, WYBuilt 1997 · S/N 650-7077

Back to AD 2006-16-18 R1